Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro T-SQL 2008 Programmer's Guide

  • Book
  • © 2008

Overview

Authors:
  1. Michael Coles
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Critical topic for anyone developing against SQL Server

  • Early to market – releases in the same month as SQL Server 2008 itself

  • Top author with consistent five-star reviews (highest-rated (on Amazon) book specifically on Transact-SQL)

  • 7749 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 52.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 (19 chapters)

  1. Front Matter

    Pages i-xxviii
    Download chapter PDF

  2. Foundations of T-SQL

    Pages 1-21

  3. T-SQL 2008 New Features

    Pages 23-60

  4. Tools of the Trade

    Pages 61-79

  5. Procedural Code and CASE Expressions

    Pages 81-115

  6. User-Defined Functions

    Pages 117-150

  7. Stored Procedures

    Pages 151-185

  8. Triggers

    Pages 187-218

  9. Encryption

    Pages 219-246

  10. Common Table Expressions and Windowing Functions

    Pages 247-272

  11. Integrated Full-Text Search

    Pages 273-298

  12. XML

    Pages 299-339

  13. XQuery and XPath

    Pages 341-386

  14. Catalog Views and Dynamic Management Views

    Pages 387-405

  15. SQL CLR Programming

    Pages 407-449

  16. .NET Client Programming

    Pages 451-494

  17. Data Services

    Pages 495-523

  18. New T-SQL Features

    Pages 525-551

  19. Error Handling and Dynamic SQL

    Pages 553-571

  20. Performance Tuning

    Pages 573-602
Back to top

Keywords

About this book

Discussing new and existing features, SQL Server designer and administrator Michael Coles takes you on an expert guided tour of Transact–SQL functionality in SQL Server 2008 in his book, Pro T–SQL 2008 Programmer's Guide. Fully functioning examples and downloadable source code bring Coles' 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.

Pro T–SQL 2008 Programmer's Guide is every developer's key to making full use of SQL Server 2008's powerful, built–in Transact–SQL language. 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 SQL Server 2008 include a spatial data type, SQLCLR integration, the MERGE statement, a dramatically improved and market–leading XML feature set, and support for encryption—all of which are covered in this book

About the author

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

Publish with us

Policies and ethics

Back to top

Search

Navigation