Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2012

Presenting at SQL Saturday #110

On Saturday, March 10, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL Saturday #110 in Tampa, FL. Come out and join me in this code filled session, where we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel… Read more

0 comments, 609 reads

Posted in A Discussion of SQL Server-Related Topics on 28 February 2012

Comparing Inline and Multi-Statement Table-Valued Functions

Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result set that can be used in queries. You can select directly against them, or utilize them with the APPLY operator. These are truly versatile additions to SQL -and  since you… Read more

7 comments, 10,681 reads

Posted in A Discussion of SQL Server-Related Topics on 15 February 2012