SQL SERVER BLOGS
SQL SERVER 2012 BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on SQL 2012 in SQL Server 2012
Showing blogs 1-3 (out of 3)
Posted by Andy Brown on 20 September 2013
SQL Server 2012 introduces new functions to find the previous or subsequent value for a row, without using a complicated self-join. This blog explains how to use LAG and LEAD, including partitioning row sets.
Posted by Andy Brown on 15 May 2012
In a previous blog on new features of SQL 2012, I missed out the ability to insert code snippets, and also to embed or surround code in an IF, BEGIN or WHILE block. This blog rectifies this!