Giới thiệu sách SQL: Pro T-SQL 2012 Programmer's Guide

About the Authors......................................................................................................xxiii
About the Technical Reviewer .................................................................................... xxv
Acknowledgments.................................................................................................... xxvii
Introduction............................................................................................................... xxix
■Chapter 1: Foundations of T-SQL .................................................................................1
■Chapter 2: Tools of the Trade.....................................................................................19
■Chapter 3: Procedural Code and CASE Expressions ..................................................47
■Chapter 4: User-Defned Functions............................................................................79
■Chapter 5: Stored Procedures .................................................................................111
■Chapter 6: Triggers..................................................................................................151
■Chapter 7: Encryption..............................................................................................179
■Chapter 8: Common Table Expressions and Windowing Functions .........................205
■Chapter 9: Data Types and Advanced Data Types....................................................239
■Chapter 10: Full-Text Search ...................................................................................287
■Chapter 11: XML ......................................................................................................317
■Chapter 12: XQuery and XPath ................................................................................355
■Chapter 13: Catalog Views and Dynamic Management Views ................................399
■Chapter 14: CLR Integration Programming..............................................................425
■Chapter 15: .NET Client Programming.....................................................................469
■Chapter 16: Data Services .......................................................................................517
vi
■Chapter 17: Error Handling and Dynamic SQL.........................................................545
■Chapter 18: Performance Tuning.............................................................................567
■Appendix A: Exercise Answers ................................................................................607
■Appendix B: XQuery Data Types...............................................................................617
■Appendix C: Glossary...............................................................................................623
■Appendix D: SQLCMD Quick Reference....................................................................635
Index...........................................................................................................................643