Skip to main content
SpringerLink
Log in
Apress
Book cover

SQL Server 2005 T-SQL Recipes

A Problem-Solution Approach

  • Book
  • © 2006

Overview

Authors:
  1. Joseph Sack
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Comprehensive T-SQL Coverage, including all SQL Server 2005 new features, from an established SQL Server expert and author

  • Broad appeal, with practical ‘How to’ answers to common SQL Server T-SQL questions for both novice and advanced DBAs and developers

  • Unique, easy-reference format – ideal for preparing for a SQL Server job interview, or for a SQL Server certification test

  • 10k Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (29 chapters)

  1. Front Matter

    Pages i-xxix
    Download chapter PDF

  2. Select

    Pages 1-59

  3. Insert, Update, Delete

    Pages 61-82

  4. Transactions, Locking, Blocking, and Deadlocking

    Pages 83-107

  5. Tables

    Pages 109-153

  6. Indexes

    Pages 155-171

  7. Full-Text Search

    Pages 173-189

  8. Views

    Pages 191-207

  9. SQL Server Functions

    Pages 209-253

  10. Conditional Processing, Control-of-Flow, and Cursors

    Pages 255-270

  11. Stored Procedures

    Pages 271-287

  12. User-Defined Functions and Types

    Pages 289-312

  13. Triggers

    Pages 313-336

  14. CLR Integration

    Pages 337-353

  15. XML

    Pages 355-374

  16. Web Services

    Pages 375-391

  17. Error Handling

    Pages 393-406

  18. Principals

    Pages 407-432

  19. Securables and Permissions

    Pages 433-458

  20. Encryption

    Pages 459-484
Back to top

Keywords

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.

About the author

Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the Microsoft Certified Master: SQL Server 2005 certification; and in 2008, he earned the Microsoft Certified Master: SQL Server 2008 certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, SQL Server 2008 Transact-SQL Recipes (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation