0
POPSBasic & Practical Use of LINQ (not db related) Most of the time we (or may be it is only me) has a misconception that LINQ has alwasy to be associated with database like MS SQL. But to my suprise after reading this article, I finally realize the basic and practical use of LINQ aside from the wrong connotation as "stored proc replacement" The main thing that was seems important to me using LINQ on this article is that there's no need to typecast your objects(boxing and unboxing) :)
0
POPSCROSS APPLY on SQL 2005 With this, you would be able to use fields from your select statement within your inner join subquery or udf :) Remember the compatibility level of the database must be set to 90. ex. exec sp_dbcmptlevel MyDb, 90