Pro T-SQL 2012 Programmer's Guide, 3rd Edition

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-Defined 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