SQL Server 2008 T-SQL Enhancements - Part 1/6
One of the things that inspires me the most in SQL Server, is the continuous enhancement of its programmability features like Data Access (Entity Framework and Data Services support), Visual Studio Integration, LINQ, Sync Framework, Project "Velocity" and of course, T-SQL Enhancements!
This webcast discusses the following features:
-Variables Declaration and Initialization
-Compound Assignment Operators
-Large UDTs
-DATE, TIME, DATETIME2
-New & Enhanced Functions supporting DATETIME2 Precision
-Table Value Constructors (Row Constructors)
-Table Types and Table-Valued Parameters (TVPs)
-The MERGE Statement
-Grouping Sets
-Object Dependencies
-HIERARCHYID Data Type
-DDL Trigger Enhancements
-Collation Alignment with Windows