Opera Unite : Brower based Web Server
Monday, November 23, 2009
Saturday, November 21, 2009
Glimmer
Glimmer - Glimmer allows you to easily create interactive elements on your web pages by harnessing the power of the jQuery library.
Wednesday, October 14, 2009
Friday, August 28, 2009
Friday, March 13, 2009
SQL 2005: (Table) JOIN (Table Valued Function)
In SQL 2005, I had to write a Query in which a TVF(Table Valued Function) should be joined with a Table. The TVF had a Parameter which should be joined to the Table's Column
TVF - MyFunction(@ID)
Table - MyTable (with a Column ID)
Here the MyTable.ID should be joined with the MyFunction(@ID) to produce the results. The normal JOIN will not work in this case. This should be done by using CROSS APPLY feature:
SELECT * FROM MyTable T CROSS APPLY MyFunction(T.ID)
CROSS APPLY = Table INNER JOIN TVF
In case of LEFT JOINing use 'OUTER APPLY' like this:
SSELECT * FROM MyTable T OUTER APPLY MyFunction(T.ID)
OUTER APPLY = Table LEFT OUTER JOIN TVF
Note: No need to USE 'ON' clause
TVF - MyFunction(@ID)
Table - MyTable (with a Column ID)
Here the MyTable.ID should be joined with the MyFunction(@ID) to produce the results. The normal JOIN will not work in this case. This should be done by using CROSS APPLY feature:
SELECT * FROM MyTable T CROSS APPLY MyFunction(T.ID)
CROSS APPLY = Table INNER JOIN TVF
In case of LEFT JOINing use 'OUTER APPLY' like this:
SSELECT * FROM MyTable T OUTER APPLY MyFunction(T.ID)
OUTER APPLY = Table LEFT OUTER JOIN TVF
Note: No need to USE 'ON' clause
Monday, March 9, 2009
Monday, March 2, 2009
Monday, February 9, 2009
Sunday, February 8, 2009
I'm a PC....
Tuesday, January 20, 2009
Subscribe to:
Posts (Atom)
