Ben-Gan, Sarka, Wolter -- Inside Microsoft SQL Server 2005 T-SQL...

Inside Microsoft SQL Server 2005: T-SQL Programming
Authors: Itzik Ben-Gan, Dejan Sarka, Roger Wolter


Genres
Technical

Description:
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 the programming language—solving complex problems with real-world solutions.



Discover how to:

Understand when to apply set-based programming techniques
Design and implement date and time-related XML and CLR datatypes
Use temporary objects, including temporary tables, table variables, and table expressions
Work with T-SQL and CLR user-defined functions, stored procedures, and triggers
Support user input-based queries and variable data with dynamic execution
Work with transactions and new exception handling constructs
Apply a concurrency model to support simultaneous users
Use Service Broker for controlled asynchronous processing in database applications


This book includes code samples on the Web.

Goodreads page:
https://www.goodreads.com/book/show/26281.Inside_Microsoft_SQL_Server_2005

Please note that this description is auto-generated by a bot, if you find the description incorrect then please report in the comments. Description will be edited accordingly afterwards.