http://www.sqlservercentral.com/blogs/jamesserra/2012/02/15/sql-server-2012-denali-t-sql-enhancements/

Printed 2014/10/23 04:27AM

SQL Server 2012 (“Denali”): T-SQL Enhancements

2012/02/15

SQL Server 2012 has a number of new T-SQL features.  Listed below are all of the new features, along with the best links I have found that describe each feature:

WITH RESULT SETS, OFFSET AND FETCH, THROW, SEQUENCE: See New T-SQL Features in SQL Server 2012 and SQL Server 2012-DENALI-whats new in T-SQL

FORCESEEK and FORCESCAN: See FORCESEEK and FORCESCAN – New enhancements with Table hints in SQL Server Denali CTP3

Conversion functions: See New Built-in Functions in SQL Server 2012 Denali and SQL Server 2012 – new conversion functions

Date and time functions: See New Date and Time Functions in SQL Server 2012

Logical functions: See New Logical Functions in SQL Server 2012 (IIF and CHOOSE)

String functions: See CONCAT() string function–SQL Server 2012 and SQL Server v.Next (Denali) : CTP3 T-SQL Enhancements : FORMAT()

Analytic functions: See The new Analytic functions in SQL Server 2012

More info:

Video The T-SQL Cookbook: What’s Cool in Microsoft SQL Server 2008 R2 and New in SQL Server Code-Named Denali”

Programmability Enhancements (Database Engine)


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.