SQL Server 2008 has plenty of new, improved and updated features including extensions to Transact SQL. In this presentation Martin will demonstrate some of the new T-SQL features including:
- Row Constructors
- Merge
- Hierarchy Id Data Type
- Sparse Column and Column Sets
- Grouping Sets
- Filestream Storage
- User Defined Table Type
- Table Valued Parameters
- Date and Time Functionality
- Dependency Reporting