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)
No comments:
Post a Comment