Skip to main content
  • Book
  • © 2012

Pro T-SQL 2012 Programmer's Guide

Apress

Authors:

  • Programmer’s Guide is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language.

  • 16k Accesses

Buy it now

Buying options

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

  1. Front Matter

    Pages i-xxxiv
  2. Foundations of T-SQL

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 1-17
  3. Tools of the Trade

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 19-45
  4. Procedural Code and CASE Expressions

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 47-77
  5. User-Defined Functions

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 79-109
  6. Stored Procedures

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 111-149
  7. Triggers

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 151-178
  8. Encryption

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 179-203
  9. Common Table Expressions and Windowing Functions

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 205-237
  10. Data Types and Advanced Data Types

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 239-286
  11. Full-Text Search

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 287-315
  12. XML

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 317-354
  13. XQuery and XPath

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 355-398
  14. Catalog Views and Dynamic Management Views

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 399-424
  15. CLR Integration Programming

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 425-467
  16. .NET Client Programming

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 469-515
  17. Data Services

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 517-544
  18. Error Handling and Dynamic SQL

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 545-566
  19. Performance Tuning

    • Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles
    Pages 567-606
  20. Back Matter

    Pages 607-659

About this book

Pro T–SQL 2012 Programmer’s Guide is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success.

Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks.

About the authors

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Bibliographic Information

  • Book Title: Pro T-SQL 2012 Programmer's Guide

  • Authors: Jay Natarajan, Rudi Bruchez, Scott Shaw, Michael Coles

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

  • Publisher: Apress Berkeley, CA

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

  • Copyright Information: Michael Coles and Scott Shaw and Jay Natarajan and Rudi Bruchez 2012

  • Softcover ISBN: 978-1-4302-4596-4Published: 26 September 2012

  • eBook ISBN: 978-1-4302-4597-1Published: 29 November 2012

  • Edition Number: 3

  • Number of Pages: XXXIV, 696

  • Topics: Database Management

Buy it now

Buying options

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