T-SQL is the fundamental language for database programming in SQL Server 2005. All professional SQL Server users need to know it and, even more important, must understand how to use it well. To achieve this they need a convenient single source of information and advice. This book provides that, clearly and comprehensively. Both database administrators and developers will find this highly readable, detailed description of T-SQL an eye-opening and invaluable reference for as long as they work with SQL Server 2005. The author has over a decade's experience designing and administering SQL Server databases.
Auflage
Sprache
Verlagsort
Zielgruppe
Illustrationen
Maße
Höhe: 235 mm
Breite: 191 mm
Dicke: 30 mm
Gewicht
ISBN-13
978-1-59059-794-1 (9781590597941)
DOI
10.1007/978-1-4302-0387-2
Schweitzer Klassifikation
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.
