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 
(no tags)