+612 9045 4394
Pro T-SQL 2008 Programmer's Guide : Expert's Voice in SQL Server - Michael Coles

Pro T-SQL 2008 Programmer's Guide

Expert's Voice in SQL Server

Paperback Published: 1st August 2008
ISBN: 9781430210016
Number Of Pages: 659

Share This Book:
Ships in 7 to 10 business days

Earn 145 Qantas Points
on 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

Foundations of T-SQLp. 1
T-SQL 2008 New Featuresp. 23
Tools of the Tradep. 61
Procedural Code and CASE Expressionsp. 81
User-Defined Functionsp. 117
Stored Proceduresp. 151
Triggersp. 187
Encryptionp. 219
Common Table Expressions and Windowing Functionsp. 247
Integrated Full-Text Searchp. 273
XMLp. 299
XQuery and XPathp. 341
Catalog Views and Dynamic Management Viewsp. 387
SQL CLR Programmingp. 407
.NET Client Programmingp. 451
Data Servicesp. 495
New T-SQL Featuresp. 525
Error Handling and Dynamic SQLp. 553
Performance Tuningp. 573
Exercise Answersp. 603
XQuery Data Typesp. 613
Glossaryp. 619
SQLCMD Quick Referencep. 631
Indexp. 639
Table of Contents provided by Blackwell. All Rights Reserved.

ISBN: 9781430210016
ISBN-10: 143021001X
Series: Expert's Voice in SQL Server
Audience: General
Format: Paperback
Language: English
Number Of Pages: 659
Published: 1st August 2008
Publisher: Springer-Verlag Berlin and Heidelberg Gmbh & Co. Kg
Country of Publication: US
Dimensions (cm): 19.05 x 23.11  x 3.81
Weight (kg): 1.11

Earn 145 Qantas Points
on this Book