Pro SQL Server 2005 T-SQL and Stored Procedure Programming
Published on 1. January 2008
Book
Paperback/Softback
650 pages
978-1-59059-654-8 (ISBN)
Description
"Pro SQL Server 2005 T-SQL and Stored Procedure Programming" deals with computers/software.
More details
Edition
2007 ed.
Language
English
Place of publication
New York
United States
Target group
Professional and scholarly
Popular/general
Dimensions
Height: 235 mm
Width: 178 mm
ISBN-13
978-1-59059-654-8 (9781590596548)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Garth Wells is an independent consultant (www.Data-Driven.com) who has worked in database design and development for more than twelve years and with SQL Server since version 4.2a. This is his third book on SQL Server. He has successfully managed and/or implemented database solutions in the following industries: Automobile Finance, Commercial Real Estate Management, Computer Design and Manufacturing, Medical Informatics, Mortgage Finance, and Software Development.
Content
T-SQL Overview.- Data Types.- Data Definition Language.- DML: SELECT, JOINs, and Control-of-Flow.- DML: Inserting, Updating, and Deleting Data.- Built-In Functions.- User-Defined Functions.- Views.- System Stored Procedures.- Extended Stored Procedures.- User-Defined Stored Procedures.- Handling XML.- CLR Procedures.- Triggers.- Procedures and Triggers by Example.- Query Optimization and Application Performance.