wackoyacky's sql clipmarks

Newest Clips

see Newest Clips

See all clipmarks by wackoyacky

See all public sql clipmarks

0
POPS Basic & Practical Use of LINQ (not db related)

by wackoyacky 12-26-2007

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
POPS Sequential Ordering on SQL 2005

by wackoyacky 11-27-2007

No Remarks

0
POPS CROSS APPLY on SQL 2005

by wackoyacky 11-27-2007

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

0
POPS SQL Determine The Row Size Of All The Tables

by wackoyacky 6-21-2007

No Remarks

— end of the list —