T-SQL Enhancements (Section 7)
Today's section was a blur - 42 slides and 7 demos in 55 minutes. I have included in my download my copy of the slides which hass some of my talking point notes (somethings I spoke off-the-cuff) for those you will need to catch the webcast again.
Anyway today we discussed:
The Try-CATCH exception handling, and the additional information methods to return error information
The new and VERY useful Common Table Expressions (Use these often)
The PIVOT and UNPIVOT - which when needed are invaluable
The modified EXCEPT and INTERSECTION - not necessarily new, but still useful (they were available in a different form previously)
The CROSS and OUTER Apply and the ability to JOIN with an UDF
The modified TOP feature
And the very useful OUTPUT feature to pipe back results as a table from UPDATE, DELETE, and INSERT statements
I hope you found it useful, I know I spoke a bit fast. If you have any additional questions fee free to email me. Here is the files for Download - http://www.neudesic.com/uploads/steve_muise/07_TSQL_DML.zip
Thanks again and see you in 2 weeks