SQL Server 2008 New Features

Microsoft SQL Server 2008 introduces several important new Transact SQL programmability features and enhances some existing ones

 

Following is the list of key new features

1.Initializing variables

2.Compound assignment operators

3.Enhanced CONVERT function

4.New date and time data types

5.New date and time functions

6.The MERGE statement

7.Grouping sets

8.Table valued parameters

9.Large user-defined types

10.Table value constructor support

11.DDL trigger enhancements

12.Sparse columns

13.Filtered indexes

We will provide the information in detail in next section.