Introduction:
In this article,i am going to explain about the new T-sql enhancements in sql server 2008.

Main:
We’ll continue with an in-depth look at these significant T-SQL features, which are new in SQL Server 2008:

Table-valued parameters (TVPs)

New date and time data types

The MERGE statement

The INSERT OVER DML syntax

The GROUPING SETS operator

New T-SQL shorthand syntax

T-SQL provides several important “beyond relational” data types as well, such as the xml, hierarchyid, varbinary(max) FILESTREAM,
geography, and geometry data types.

Conclusion:
Hope this helps,
Happy Coding.