Pro T-SQL 2008 Programmer's Guide
by Coles, MichaelFormat: Paperback
Pub. Date: 2008-08-18
Publisher(s): Apress
Other versions by this Author
List Price: $55.64
Buy New
Usually Ships in 2-3 Business Days.
$52.99
Rent Book
Select for Price
Rent Digital
$39.00*
Used Book
We're Sorry
Sold Out
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
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
Table of Contents
| Foundations of T-SQL | p. 1 |
| T-SQL 2008 New Features | p. 23 |
| Tools of the Trade | p. 61 |
| Procedural Code and CASE Expressions | p. 81 |
| User-Defined Functions | p. 117 |
| Stored Procedures | p. 151 |
| Triggers | p. 187 |
| Encryption | p. 219 |
| Common Table Expressions and Windowing Functions | p. 247 |
| Integrated Full-Text Search | p. 273 |
| XML | p. 299 |
| XQuery and XPath | p. 341 |
| Catalog Views and Dynamic Management Views | p. 387 |
| SQL CLR Programming | p. 407 |
| .NET Client Programming | p. 451 |
| Data Services | p. 495 |
| New T-SQL Features | p. 525 |
| Error Handling and Dynamic SQL | p. 553 |
| Performance Tuning | p. 573 |
| Exercise Answers | p. 603 |
| XQuery Data Types | p. 613 |
| Glossary | p. 619 |
| SQLCMD Quick Reference | p. 631 |
| Index | p. 639 |
| Table of Contents provided by Blackwell. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.