BY TOPIC▼
PROGRAMMING BLOGS▼
T-SQL BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on New features in T-SQL
Showing blogs 1-4 (out of 4)
How to use the LAG and LEAD functions included in SQL Server 2012
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.
Wise Owl suggestions for new features for SQL Server Management Studio
Posted by Andy Brown on 09 September 2013
Writing SQL in Management Studio could, Wise Owl feel, be made a little easier: here are 10 practical suggestions for how!
New in SQL 2012 - code snippets and surrounding code
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!
New features for SQL within SQL Server 2012
Posted by Andy Brown on 08 May 2012
SQL 2012 has 14 new functions, a new FileTable construct and new ways to sequence and fetch records - as this blog explains.