|
|
SQL Server 2000 Stored Procedure Programming
Now on Amazon.com and Chapters.ca
Trigon Blue consultants Dejan Sunderic and
Tom Woodhead recently teamed up to write SQL Server 2000 Stored Procedure
Programming, a book that fills a huge gap
in the field of Microsoft SQL Server development and DBA
documentation. The book was released by Osborne
/ McGraw-Hill in early
October, shortly after Microsoft released SQL Server 2000 to General
Availability.
Description
Design, deploy, and manage stored
procedures in enterprise data applications.Write scalable, high-performance
SQL Server applications using stored procedures. 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 experts
provide concise explanations, design recommendations, many examples, and a
real-world case study. If you're looking for in-depth details on SQL
Server stored procedures, look inside.
- 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, and cursors
- Write code to interact with COM, mail, 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
Authors
-
Dejan Sunderic, BSc, MCSD, CMSSP, is the Principal Consultant at Trigon Blue Inc.
As a Microsoft Certified Solution Provider, Trigon Blue specializes in database
administration and development, and application development for the Internet and
Windows platforms. Dejan has written three books and numerous technical articles
for several computer and professional publications.
-
Tom Woodhead, MA, is an independent
documentation and
marketing consultant who has worked with development teams in diverse
environments, including multinational corporations, software companies of all
sizes, and Internet start-ups.
Publisher
Osborne/McGraw-Hill
Pages: 720
ISBN: 0-07-212566-7
EAN: 9780072125665
UPC: 783254033788
|
