SQL Server, Client-Server Computing

Sql Server 2000 Stored Procedure Programming

Name: Sql Server 2000 Stored Procedure Programming
Author: Dejan Sunderic
ISBN: 9780072125665

by Dejan Sunderic, Tom Woodhead

Available on Bookshop Write a review

Books.org participates in affiliate programs including Bookshop.org and the Amazon Services LLC Associates Program. We may earn a commission from qualifying purchases made through links on this page, at no additional cost to you.

Overview

"Tired of pubs and Northwind? Tired of books that just lie there? This book will engage you interactively with its sample Asset tracking database and end-of-chapter exercises. You'll learn by doing. "

—Karen Watterson,Editor,Pinnacle Publishing's SQL Server Professional

"Finally! This book dedicated to T-SQL Stored Procedure development is long overdue. . . a must have for the developer who is serious about creating powerful and scalable SQL Server 2000 architectures. "

—Ed Musters,Chief Technology Officer,Sage Information Consultants,Inc.

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 procedures
Adopt tips and tricks using identity,timestamp,sql_variant,uniqueidentifier,optimistic locking,dynamically constructed queries,temporary tables,andcursors
Write code to interact with COM,mai,executables,the Registry,jobs,and security
Manage application security
Locate and fix semantic errors using TSQL Debugger in Query Analyzer,Visual Basic,or Visual Studio,and using manual debugging techniques
Create user-defined,table-valued,and in-line functions
Design instead-of triggers and after triggers
Manage transactions and locks
Develop dynamic,Web-based applications using SQL Server's XML capabilities

Synopsis

SQL Server 2000 Stored Procedure Programming shows you how to use Transact-SQL to design, debug, and manage custom stored procedures, functions, and triggers.