Pro T-SQL 2012 Programmer’s Guide

1. Foundations of T-SQL
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

2. Tools of the Trade
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

3. Procedural Code and CASE Expressions
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

4. User-Defined Functions
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

5. Stored Procedures
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

6. Triggers
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

7. Encryption
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

8. Common Table Expressions and Windowing Functions
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

9. Data Types and Advanced Data Types
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

10. Full-Text Search
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

11. XML
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

12. XQuery and XPath
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

13. Catalog Views and Dynamic Management Views
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

14. CLR Integration Programming
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

15. .NET Client Programming
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

16. Data Services
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

17. Error Handling and Dynamic SQL
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

18. Performance Tuning
Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

Nyckelord: Computer Science, Database Management