Inside Microsoft® SQL Server® 2008: T-SQL Programming (Developer Reference) 1st Edition

Автор: Itzik Ben-Gan, Greg Low, Roger Wolter, Isaac Kunen, Ed Katibah, Dejan Sarka

Видавництво: Microsoft Press

В наявності

Кількість сторінок640

Рік видання2010

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language-solving complex problems with real-world solutions.

Discover how to:

Work with T-SQL and CLR user-defined functions, stored procedures, and triggers.
Handle transactions, concurrency, and error handling.
Efficiently use temporary objects, including temporary tables, table variables, and table expressions.
Evaluate when to use set-based programming techniques and when to use cursors.
Work with dynamic SQL in an efficient and secure manner.
Treat date- and time-related data in a robust manner.
Develop CLR user-defined types and learn about temporal support in the relational model.