Titre : | Inside microsoft : SQL servers 2005 : T-SQL programming |
Auteurs : | Itzik Ben-gan ; Dejan Sarka ; Roger Wolter |
Type de document : | Books |
Editeur : | Washington : Microsoft, 2006 |
Article en page(s) : | XXIII, 508 p. |
Collection : | Additional resources for developers |
ISBN/ISSN/EAN : | 978-0-7356-2197-8 |
Langues: | Anglais |
Tags : | SQL (Computer program language) |
Résumé : |
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 |