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

pro t-sql programmer's guide

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