T-SQL Programming

T-SQL Programming : Inside Microsoft SQL Server 2005

By (author) , By (author)

List price: US$44.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


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.

show more

Product details

  • Paperback | 544 pages
  • 186 x 228 x 36mm | 1,079.54g
  • Microsoft Press,U.S.
  • Redmond, United States
  • English
  • black & white illustrations
  • 0735621977
  • 9780735621978
  • 929,814

Other books in Database Programming

Other people who viewed this bought

About Itzik Ben-Gan

Dejan Sarka is MCT and MCDBA certified and a Microsoft' MVP for SQL Server'. He teaches and consults for Solid Quality Mentors, speaks at TechEd and PASS, and develops OLTP, OLAP, and data mining solutions.

show more