SQL Server Denali CTP3 has been launched and it come up with many new features and enhancements. I Explored many functions and features added to Denali (MSSQL2011). Many awaited functions has been added to it. There has been considerable enhancement in SQL Development, BI and DBA side. I have started exploring Denali and found many features which are really good and can make your life very easy when working with T-SQL. Following is list of functions and features added to denali.
- Maximum Capacity Specification For SQL Server 2011 (Code Named Denali)
- 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)
- Sequence Number In SQL Server 2011 (Code Named Denali)
- PARSE and TRY_PARSE In SQL Server 2011(Code Named Denali)
- TRY_CONVERT In SQL Server 2011(Code Named Denali)
- Re-Throwing Except From TRY CATCH Block In SQL Server (Code Named Denali)
- Generating DateTime From Year, Month and Day and Different Parts of Date and Time In SQL Server
- Finding Last Date Of Month In SQL Server 2011(Code Named Denali)
- Changing Field And Data Type Using WITH RESULT SET IN EXECUTE Command In SQL Server
- Maximum Article and Table Column In SQL Server 2011 Replication (Code Named Denali)
No comments:
Post a Comment