SQL Server 2005 T-SQL Recipes

A Problem-Solution Approach

  • Authors
  • Joseph Sack

Table of contents

  1. Front Matter
    Pages i-xxix
  2. Pages 1-59
  3. Pages 109-153
  4. Pages 155-171
  5. Pages 173-189
  6. Pages 191-207
  7. Pages 209-253
  8. Pages 271-287
  9. Pages 313-336
  10. Pages 337-353
  11. XML
    Pages 355-374
  12. Pages 375-391
  13. Pages 393-406
  14. Pages 407-432
  15. Pages 459-484
  16. Pages 485-516
  17. Pages 595-614
  18. Pages 615-620
  19. Pages 637-681
  20. Pages 683-716
  21. Back Matter
    Pages 717-733

About this book


Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQL related features. SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach is an ideal book, whatever your level as a database administrator or developer.

This no-fluff desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory.

Additionally, this book provides how-to answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.


Microsoft SQL Server SQL SQL Server 2005 SQL programming T-SQL Transact-SQL XML

Bibliographic information