New Feature and Enhancement In SQL Server 2012 (Code Named Denali)

SQL Server 2011 (Code Named Denali) CTP 3 has been launched and Can be downloaded from following link. Denali has come with many exciting features for DBAs, BI Developers and SQL Developers. I have found lots of new functions which were most awaited. There are certain function which are easy to use and will make SQL Developers life very easy.

I have explored some of the feature and found them really useful from development point of view.

Download : Microsoft Download Center

• Paging With SQL Server 2011 (Code Named Denali) Using Offset Clause.
• CONCAT() New Function In SQL Server 2011 (Code Named Denali)
• Date Time Format With New FORMAT() function In SQL Server 2011 (Code Named Denali)
• Formatting Numeric And Currency With FORMAT() Along With CULTURE
• Analytic Function In SQL Server 2011 (Code Named Denali)
• CHOOSE() Function In SQL Server 2011 (Code Named Denali)
• New Inline function IIF In SQL Server 2011 (Code Named Denali)