Pro T-SQL Programmer's Guide

✍ Scribed by Miguel Cebollero, Jay Natarajan, Michael Coles (auth.)

• Publisher: Apress
• Year: 2015
• Tongue: English
• Leaves: 727
• Edition: 4
• Category: Library

✦ Synopsis

Pro T–SQL Programmer’s Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.

Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. Support for in-memory stored procedures running queries against in-memory tables is new in the language and gets coverage in this edition. Also covered are must-know features such as window functions and data paging that help in writing fast-performing database queries. Developers and DBAs alike can benefit from the expressive power of T-SQL, and Pro T-SQL Programmer's Guide is your roadmap to success in applying this increasingly important database language to everyday business and technical tasks.

• Covers the newly-introduced, in-memory database features
• Shares the best practices used by experienced professionals
• Goes deeply into the subject matter − an advanced book for the serious reader

✦ Table of Contents

Front Matter....Pages i-xxxiv
Foundations of T-SQL....Pages 1-18
Tools of the Trade....Pages 19-46
Procedural Code....Pages 47-77
User-Defined Functions....Pages 79-110
Stored Procedures....Pages 111-151
In-Memory Programming....Pages 153-176
Triggers....Pages 177-205
Encryption....Pages 207-232
Common Table Expressions and Windowing Functions....Pages 233-268
Data Types and Advanced Data Types....Pages 269-315
Full-Text Search....Pages 317-345
XML....Pages 347-385
XQuery and XPath....Pages 387-431
Catalog Views and Dynamic aent Views....Pages 433-460
.NET Client Programming....Pages 461-510
CLR Integration Programming....Pages 511-557
Data Services....Pages 559-587
Error Handling and Dynamic SQL....Pages 589-612
Performance Tuning....Pages 613-651
Exercise Answers....Pages 653-662
XQuery Data Types....Pages 663-668
Glossary....Pages 669-681
SQLCMD Quick Reference....Pages 683-691
Back Matter....Pages 693-707

✦ Subjects

Database Management