TSQL New Features in SQL Server 2008

Briefly, here are the new T-SQL programmability enhancements in SQL Server 2008: 1. Data Types a. New Date/time types (date, time, datetime2, datetimeoffset) b. New table types (i.e. CREATE TYPE myT AS table (a int, b varchar(100)) ) 2. SQL language a. MERGE statement b. GROUPING SET 3. T-SQL procedure language a. Table valued parameter…

0