"Pro SQL Server 2005 T-SQL and Stored Procedure Programming" deals with computers/software.
Auflage
Sprache
Verlagsort
Zielgruppe
Für Beruf und Forschung
Popular/general
Maße
Höhe: 235 mm
Breite: 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 Klassifikation
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.
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.
