Skip to main content
  • Book
  • © 2012

SQL Server 2012 T-SQL Recipes

A Problem-Solution Approach

Apress
  • SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012.

  • It provides ready-to-implement solutions to common programming and database administration tasks.

Buy it now

Buying options

eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 79.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

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

Table of contents (30 chapters)

  1. Front Matter

    Pages i-lv
  2. Getting Started with SELECT

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 1-21
  3. Elementary Programming

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 23-39
  4. NULLs and Other Pitfalls

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 41-55
  5. Querying from Multiple Tables

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 57-78
  6. Grouping and Summarizing

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 79-92
  7. Advanced Select Techniques

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 93-113
  8. Aggregations and Windowing

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 115-146
  9. Inserting, Updating, Deleting

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 147-178
  10. Working with Strings

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 179-195
  11. Working with Dates and Times

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 197-217
  12. Working with Numbers

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 219-240
  13. Transactions, Locking, Blocking, and Deadlocking

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 241-271
  14. Managing Tables

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 273-300
  15. Managing Views

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 301-318
  16. Managing Large Tables and Databases

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 319-340
  17. Managing Indexes

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 341-362
  18. Stored Procedures

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 363-382
  19. User-Defined Functions and Types

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 383-413
  20. Triggers

    • Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield
    Pages 415-446

About this book

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed.

  • Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
  • Current: Newly updated for SQL Server 2012
  • Comprehensive: Covers all common T-SQL problem domains

About the authors

Jason Brimhall is first and foremost a family man. He has 15+ yrs experience in IT and has worked with SQL Server starting with SQL Server 6.5. He has worked for both large and small companies in varied industries. He has experience in performance tuning, high transaction environments, large environments, and VLDBs. He is currently a DB Architect and an MCITP for SQL 2008. Jason regularly volunteers for PASS and is the VP of the Las Vegas User Group (SSSOLV). You can read more more from Jason on his blog at: http://jasonbrimhall.info.

Bibliographic Information

  • Book Title: SQL Server 2012 T-SQL Recipes

  • Book Subtitle: A Problem-Solution Approach

  • Authors: Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield

  • DOI: https://doi.org/10.1007/978-1-4302-4201-7

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books

  • Copyright Information: Jason Brimhall and David Dye and Timothy Roberts and Wayne Sheffield and Jonathan Gennick and Joseph Sack 2012

  • Softcover ISBN: 978-1-4302-4200-0Published: 11 September 2012

  • eBook ISBN: 978-1-4302-4201-7Published: 15 October 2012

  • Edition Number: 3

  • Number of Pages: LIII, 808

  • Number of Illustrations: 22 b/w illustrations

  • Topics: Database Management

Buy it now

Buying options

eBook USD 59.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 79.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