SQL Server 2000 Stored Procedure Programming

Paperback | October 2, 2000

byDejan Sunderic, Tom Woodhead

not yet rated|write a review
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 ProfessionalFinally! 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.

Pricing and Purchase Info

$64.03 online
$71.95 list price (save 11%)
In stock online
Ships free on orders over $25

From the Publisher

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 ProfessionalFinally! This book dedicated to T-SQL Stored Procedure development i...

From the Jacket

Design, deploy, and manage stored procedures in enterprise data applicationsSQL 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, ...

Dejan Sunderic (Toronto, Ontario) MCSD is the Principal Consultant at Sage Information Consultants, Inc., a consulting company based in Toronto specializing in development and infrastructure solutions.

other books by Dejan Sunderic

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
Microsoft SQL Server 2005 Stored Procedure Programming ...

Paperback|Jun 8 2006

$64.03 online$71.95list price(save 11%)
SQL Server 2000 Stored Procedure Programming
SQL Server 2000 Stored Procedure Programming

Kobo ebook|Oct 1 2000

$61.69 online$80.05list price(save 22%)
Format:PaperbackDimensions:720 pages, 9.1 × 7.3 × 1.95 inPublished:October 2, 2000Publisher:McGraw-Hill Osborne MediaLanguage:English

The following ISBNs are associated with this title:

ISBN - 10:0072125667

ISBN - 13:9780072125665

Look for similar items by category:


Rated 1 out of 5 by from The download is annoying. This book is okay, but the "sample asset db" download website (page 9) is extremely annoying. First, it's not very easy for you to find the download link unless you read through the entire ad. And when you finally find the link, it tells you your security settings are not good enough for the download and no explanation of what settings. When you want to contact them, you must fill-in a big long form before it will summit your question. and they take a day to reply. Who needs this hassel. This book should include a CD instead of this download junk to get you to fill in your personal infomation.
Date published: 2001-02-15
Rated 5 out of 5 by from A gem of a book Sunderic and Woodhead have written a gem of a book that can earn on place on almost every SQL Server 2000 developer's bookshelf, if not desk. Whether you are an experienced developer new to SQL Server, or an old hand upgrading to 2000, SQL Server 2000 Stored Procedure Programming will introduce you to the features you need to know about. The writing style is clear and easy to read, and the explanations clear, concise and comprehensive. The book concludes with an excellent chapter on XML support in SQL Server 2000. It starts with a summary of XML, DFDs and Schemas, and Style Sheets, sufficient to allow a reader new to XML at least follow along with the discussion. Then it goes into details of why and how to receive recordsets from SQL Server 200 in XML, so as to facilitate publication to The Web or an intranet. The ease with which customization, and translation into HTML, can be accomplished is readily apparent from the authors’ explanation. Any developers new to XML, who desires to easily publish database content, will find this chapter an invaluable introduction. In conclusion, this book was a most enjoyable read that I expect to keep by my desk for quite some time.
Date published: 2000-12-20
Rated 5 out of 5 by from Great book Everybody's talking about XML these days and now even SQL Server supports it. This book has a great introduction to XML for DBAs - everything you ever wanted to know about tags, elements, attributes, DTDs, schemas and XPath, but were afraid to ask. After introducing XML, the authors go on to describe how Microsoft has implemented it in SQL Server, and how you can use it to build simple Web applications for querying databases and returning recordsets as XML or processing/parsing information received as an XML string. The authors also promise to cover updategrams and SOAP on their Web site as soon as information becomes available.
Date published: 2000-10-25

Extra Content

From the Author

Many years ago, when I was taking his first steps in SQLServer, I looked in vain for a resource to help me learn more about storedprocedures. At the time, it was possible to find only two types of books aboutSQL Server: books for administrators and books about the architectureof SQL Server. Of these two types of books, the latter provided the most detailon stored procedures – but generally not more than 20 to 50 pages. Since thattime, there has been no change for the better. Many books have been publishedwith "SQL Server Programming" in their title, but coverage of storedprocedures never seemed to exceed 50 pages, and, usually, half of the bookwould be dedicated to working with database access from Visual Basic, VisualInterdev, and other similar environments. These books are fine as far as theygo, but their perspective on SQL Server is simply not suited to the SQL Serverdeveloper or DBA. In May, 1999, I have decided to close the gap between whatexists and what is needed, and in October, 1999, the first version of this bookabout stored procedure development, based on SQL Server 7.0, was written.Unfortunately, it was not published immediately, because Microsoft had justannounced Shiloh (SQL Server 7.5). A year later, on September 26, 2000,Microsoft officially releases SQL Server 2000 (not 7.5 or even 8.0). We usedtwo beta versions of Shiloh, one pre-published final version of SQL Server 2000and one concomitant e-Commerce project to explore this new product, learn itsnew features, and update the existing book. One week after the official launchof SQL Server 2000 on October 4, 2000, Osborne/McGraw-Hill publishes "SQLServer 2000 Stored Procedure Programming" as part of its "DatabaseProfessional’s Library".This book offers the following:·       Design, edit, execute, manage, rename, delete,recompile, and encrypt stored procedure·       Learn all about storage, parsing, compilation, andreuse of stored procedures·       Understand system, temporary, global temporary,extended, remote, and nested stored procedures·       Create user-defined, built-in, table-valued and inlinefunctions ·       Learn about instead-of triggers and aftertriggers - design, creation and management·       Locate and fix semantic errors using TSQL Debugger inQuery Analyzer, Visual Basic, and Visual Studio, or using manual debugging techniques·       Establish a TSQL naming convention for yourproject·       Protect source code and implement version control·       Learn error handling from the casual to thereligious·       Administer SQL Server environment using system storedprocedures·       Run jobs, execute command line programs,access COM and OLE Automation objects, interact with theWindows/NT registry, send and receive e-mail·       Employ optimistic locking using timestamps·       Manage transactions, locks and isolationslevels·       Understand dynamically constructed queries·       Learn tips and tricks for using identity and uniqueidentifiervalues ·       Understand looping with cursors, temporarytables and extreme functions ·       Manage application security ·       Use SQL Server's XML capabilities to developdynamic, Web-based applications ·       Learn actively through exercises and solutions·       Covers SQL Server 2000, 7.0, 6.x (all editionsincluding MSDE)   

Table of Contents

Chapter 1: Introduction.

Chapter 2: Introduction to Transact-SQL Development.

Chapter 3: Stored Procedure Design.

Chapter 4: Basic Transact-SQL Programming Elements.

Chapter 5: Functions.

Chapter 6: Grouping Transact-SQL Statements.

Chapter 7: Error Handling and Debugging.

Chapter 8: Elements of a Professional Development Methodology.

Chapter 9: Other Types of Procedures.

Chapter 10: Advanced Stored Procedure Programming.

Chapter 11: Interaction with Environment.

Chapter 12: XML and/or Case Study - Loading Data Warehouse.

Editorial Reviews

"Finally! This comprehensive book dedicated toTransact-SQL Stored Procedure development is long overdue.  This book is a must have for the Enterpriseweb developer who is serious about creating powerful and scalableproduct architectures using SQL Server 2000. Debugging and source code management of stored proceduresare critical to the success of your team development.  Make sure this book is part of your SQL Server developmentlibrary!"Ed Musters, CTOSage Information Consultants Inc.