BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on New features in T-SQL
Showing blogs 1-4 (out of 4)
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!