Subscribe to this blog
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, 507 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
2 comments, 4,575 reads
Posted in A Discussion of SQL Server-Related Topics on 15 February 2012