Inside Microsoft SQL Server 2005: T-SQL Programming

by Itzik Ben-Gan, Dejan Sarka, Roger Wolter

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 languageOCosolving complex problems with real-world solutions.

Discover how to: Understand when to apply set-based programming techniquesDesign and implement date and time-related XML and CLR datatypesUse temporary objects, including temporary tables, table variables, and table expressionsWork with T-SQL and CLR user-defined functions, stored procedures, and triggersSupport user input-based queries and variable data with dynamic executionWork with transactions and new exception handling constructsApply a concurrency model to support simultaneous usersUse Service Broker for controlled asynchronous processing in database applicationsThis book includes code samples on the Web."

Genres: Technical

536 pages, ebook

First published May 17, 2006

About the author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Itzik Ben-Gan is a co-founder of Solid Quality Mentors, a technical education company, and is a Microsoft SQL Server MVP.