Monday 31 January 2011

New T-SQL Features in SQL Server 2011

SQL Server 2011 has several major enhancements including a new look for SSMS. SSMS is now similar to Visual Studio with greatly improved Intellisense support.

The main new TSQL features in SQL Server 2011 are:

1. WITH RESULT SETS
2. OFFSET AND FETCH
3. THROW in Error handling
4. SEQUENCE

SQL Server 2011 (or Denali) CTP is now available and can be downloaded at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9&displaylang=en