Blogs from Wise Owl on New features in T-SQL

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.