Pro T-SQL 2005 Programmer's Guide

Michael Coles (Autor)

Buch | Softcover

560 Seiten

2007 | 1st ed.
Apress (Verlag)
978-1-59059-794-1 (ISBN)

Artikel merken

Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here.

Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer's guide to T-SQL and SQL Server 2005.

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.

The Role of T-SQL.- Tools of the Trade.- T-SQL for SQL Server 2000 Programmers.- Control-of-Flow and CASE Expressions.- User-Defined Functions.- Stored Procedures.- Triggers.- T-SQL Encryption.- Error Handling and Debugging.- Dynamic SQL.- XML.- XQuery and XPath.- SQL Metadata.- SQLCLR Programming.- .NET Client Programming.- HTTP Endpoints.

Erscheint lt. Verlag	25.4.2007
Zusatzinfo	560 p.
Verlagsort	New York
Sprache	englisch
Maße	191 x 235 mm
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
	Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	1-59059-794-X / 159059794X
ISBN-13	978-1-59059-794-1 / 9781590597941
Zustand	Neuware