T-Sql Enhancements in SQL 2008
Itzik Ben-Gan taught a class on the enhancements to the t-sql language for sql 2008. Again, another great class. He announced that there would soon be a whitepaper coming out regarding this very topic. I’m assuming it will be on his site. The notes I took can be found here (05_overviewoft-sqlenhancementsinsql2008-itzikbengan) .
- The merge statement
- New assignment operators (+=, -=, etc)
- Grouping sets
- Merge statement
- Date and time enhancements (functions and datatypes)
- Table valued parameters
