Contents at a Glance
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................................................................................. 47
■Chapter 4: User-Defned Functions...................................................................... 79
■Chapter 5: Stored Procedures ........................................................................... 111
■Chapter 6: In-Memory Programming................................................................. 153
■Chapter 7: Triggers............................................................................................ 177
■Chapter 8: Encryption........................................................................................ 207
■Chapter 9: Common Table Expressions and Windowing Functions ................... 233
■Chapter 10: Data Types and Advanced Data Types............................................ 269
■Chapter 11: Full-Text Search ............................................................................. 317
■Chapter 12: XML ................................................................................................ 347
■Chapter 13: XQuery and XPath .......................................................................... 387
■Chapter 14: Catalog Views and Dynamic aent Views ........................................ 433
■Chapter 15: .NET Client Programming............................................................... 461
■Chapter 16: CLR Integration Programming........................................................ 511
■ Contents at a GlanCe
iv
■Chapter 17: Data Services ................................................................................. 559
■Chapter 18: Error Handling and Dynamic SQL................................................... 589
■Chapter 19: Performance Tuning....................................................................... 613
■Appendix A: Exercise Answers .......................................................................... 653
■Appendix B: XQuery Data Types......................................................................... 663
■Appendix C: Glossary......................................................................................... 669
■Appendix D: SQLCMD Quick Reference.............................................................. 683
Index..................................................................................................................... 693
- Log in to post comments