SQL Sever 2008 : T-SQL Enhancements

(1)Variable Initialization
(2)Compound Statements
(3)New Datatypes
DATE
TIME
DATETIME2
HIERARCHYID
(4)New function SYSDATETIME(),SYSUTCDATETIME() to support DATETIME2 values
(5)More flags added to DATEPART,DATEADD,DATEDIFF functions
(6)ROW Constructors