Logo - springer
Slogan - springer

Computer Science - Database Management & Information Retrieval | Pro T-SQL 2012 Programmer's Guide

Pro T-SQL 2012 Programmer's Guide

Coles, M., Shaw, S., Natarajan, J., Bruchez, R.

3rd ed. 2012, XXXIV, 696 p.

A product of Apress
Available Formats:
eBook
Information

Springer eBooks may be purchased by end-customers only and are sold without copy protection (DRM free). Instead, all eBooks include personalized watermarks. This means you can read the Springer eBooks across numerous devices such as Laptops, eReaders, and tablets.

You can pay for Springer eBooks with Visa, Mastercard, American Express or Paypal.

After the purchase you can directly download the eBook file or read it online in our Springer eBook Reader. Furthermore your eBook will be stored in your MySpringer account. So you can always re-download your eBooks.

 
$34.99

(net) price for USA

ISBN 978-1-4302-4597-1

digitally watermarked, no DRM

Included Format: PDF

download immediately after purchase


learn more about Springer eBooks

add to marked items

Softcover
Information

Softcover (also known as softback) version.

You can pay for Springer Books with Visa, Mastercard, American Express or Paypal.

Standard shipping is free of charge for individual customers.

 
$49.99

(net) price for USA

ISBN 978-1-4302-4596-4

free shipping for individuals worldwide

usually dispatched within 3 to 5 business days


add to marked items

    • Appeals to experienced programmers through a focus on usage and best-practice rather than on syntax and features.
    • Builds upon a foundation of 4 1/2-star reviews over the previous two editions.
    • Highlights new T-SQL features that are truly important for readers to know.
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.

Content Level » Popular/general

Related subjects » Database Management & Information Retrieval

Table of contents 

  1. Foundations of T-SQL
  2. Tools of the Trade
  3. Procedural Code and CASE Expressions
  4. User Defined Functions
  5. Stored Procedures
  6. Triggers
  7. Encryption
  8. Common Table Expressions
  9. Advanced Features
  10. Integrated Full-Text Search
  11. XML
  12. XQuery and XPath
  13. Catalog Views and Dynamic Management Views
  14. SQL CLR Programming
  15. .NET Client Programming
  16. Data Services
  17. Error Handling and Dynamic SQL
  18. Performance Monitoring and Tuning
  19. Appendix A
  20. Appendix B
  21. Appendix C
  22. Appendix D

Popular Content within this publication 

 

Articles

Read this Book on Springerlink

Services for this book

New Book Alert

Get alerted on new Springer publications in the subject area of Database Management.