Book description
A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced language features of Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples.
Table of contents
- Inside Microsoft® SQL Server™ 2005: T-SQL Programming
- A Note Regarding Supplemental Files
- Foreword
- Preface
- Acknowledgments
- Introduction
- 1. Datatype-Related Problems, XML, and CLR UDTs
- 2. Temporary Tables and Table Variables
- 3. Cursors
- 4. Dynamic SQL
- 5. Views
- 6. User-Defined Functions
- 7. Stored Procedures
- 8. Triggers
- 9. Transactions
- 10. Exception Handling
- 11. Service Broker
- A. Companion to CLR Routines
- About the Contributors
- Index
- About the Authors
- Copyright
Product information
- Title: Inside Microsoft® SQL Server™ 2005
- Author(s):
- Release date: May 2006
- Publisher(s): Microsoft Press
- ISBN: 9780735621978
You might also like
book
Microsoft® SQL Server® 2008 For Dummies®
If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get …
book
Microsoft® SQL Server® 2008 Internals
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team …
book
Microsoft® SQL Server 2008 R2 Unleashed
This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. …
book
A Developer’s Guide to SQL Server 2005
"I come from a T-SQL background, so when I first laid my eyes on SQL Server …