SQL Server 2000 Stored Procedure Programming (Paperback)

Design, deploy, and manage stored procedures in enterprise data applications

SQL Server 2000 Stored Procedure Programming shows you how to use Transact-SQL to design, debug, and manage custom stored procedures, functions, and triggers. You'll learn to manage SQL Server resources using new features of Enterprise Manager, Query analyzer, Visual Basic, and Visual Studio, implement robust error handling, and establish the professional habits you need to become an expert SQL Server developer. This guide contains simple explanations for developers who are just starting to work with stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server experts provide concise explanations, design recommendations, many examples, and a real-world case study.Design user-defined, system, temporary, global temporary, extended, remote, and nested stored proceduresAdopt tips and tricks using identity, timestamp, sql_variant, uniqueidentifier, optimistic locking, dynamically constructed queries, temporary tables, and cursorsWrite code to interact with COM, mai, executables, the Registry, jobs, and securityManage application securityLocate and fix semantic errors using TSQL Debugger in Query Analyzer, Visual Basic, or Visual Studio, and using manual debugging techniquesCreate user-defined, table-valued, and in-line functionsDesign instead-of triggers and after triggersManage transactions and locksDevelop dynamic, Web-based applications using SQL Server's XML capabilities

General

Imprint:	McGraw-Hill Professional
Country of origin:	United States
Release date:	October 2000
First published:	October 2000
Authors:	Dejan Sunderic • Tom Woodhead
Dimensions:	231 x 185 x 50mm (L x W x T)
Format:	Paperback
Pages:	752
ISBN-13:	978-0-07-212566-5
Categories:	Books > Computing & IT > Computer programming > General Books > Computing & IT > Computer software packages > Database software > General Books > Computing & IT > Applications of computing > Databases > General
LSN:	0-07-212566-7
Barcode:	9780072125665

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!