An Introduction to New T-SQL Programmability Features in SQL Server 2008

Un bellissimo whitepaper di Itzik Ben-Gan sulle nuove feature legate a T-SQL di SQL Server 2008

http://msdn.microsoft.com/en-gb/library/cc721270(SQL.100).aspx

Questo l’indice dei contenuti:

• Transact-SQL Delighters.
• Declare and Initialize Variables
• Compound Assignment Operators
• Table Value Constructor Support through the VALUES Clause.
• Enhanced CONVERT Function.
• Date and Time Data Types.
• New Data Types
• New and Enhanced Functions
• Large UDTs.
• HIERARCHYID Data Type.
• Indexing Strategies
• Inserting New Nodes
• Querying the Hierarchy.
• Other Supported Methods
• Table Types and Table-Valued Parameters.
• Table Types
• Table-Valued Parameters
• MERGE Statement
• Grouping Sets.
• GROUPING SETS, CUBE, and ROLLUP Subclauses
• Grouping Sets Algebra.
• GROUPING_ID Function.
• DDL Trigger Enhancements.
• Sparse Columns.
• Filtered Indexes and Statistics.
• SQL/CLR Enhancements.
• Enhancements to User-Defined Aggregates
• Enhancements to Table-Valued Functions
• Object Dependencies.
• Change Data Capture.
• Collation Alignment with Windows