SQL Server 2000 Stored Procedure Programming

3 avg rating
( 2 ratings by Goodreads )
9780072125665: SQL Server 2000 Stored Procedure Programming

-- Huge audience -- this book will appeal to those who bought SQL Server 7 Developer's Guide, a 25,000+ copy best-seller
-- The use of stored procedures is a required step for SQL Server developers -- this book completely addresses all aspects of use, from A-Z
-- This will be one of the first books on the market to focus solely on this topic
-- Expert author -- Sunderic writes for SQL Server Professional, Visual Basic Programmer's Journal, and other industry journals

"synopsis" may belong to another edition of this title.

Product Description:

This is a guide to building and using stored procedures in SQL server applications. Stored procedures are used for a variety of complex data gathering tasks, to optimize performance.

From the Back Cover:

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, and cursors
  • 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

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Dejan Sunderic
Published by McGraw-Hill/OsborneMedia (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill/OsborneMedia, 2000. Paperback. Book Condition: New. book. Bookseller Inventory # 0072125667

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 27.46
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Dejan Sunderic
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800721256651.0

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 30.21
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

3.

Dejan Sunderic
Published by McGraw-Hill Education - Europe (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Quantity Available: > 20
Print on Demand
Seller
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education - Europe, 2000. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780072125665

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 38.74
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

4.

Dejan Sunderic (Conductor)
Published by McGraw-Hill/OsborneMedia (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill/OsborneMedia, 2000. Paperback. Book Condition: New. Bookseller Inventory # DADAX0072125667

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 39.13
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

5.

Sunderic, Dejan
Published by McGraw-Hill/OsborneMedia 2000-10 (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Quantity Available: 5
Print on Demand
Seller
Chiron Media
(Wallingford, United Kingdom)
Rating
[?]

Book Description McGraw-Hill/OsborneMedia 2000-10, 2000. Book Condition: New. This item is printed on demand. Brand new book, sourced directly from publisher. Dispatch time is 24-48 hours from our warehouse. Book will be sent in robust, secure packaging to ensure it reaches you securely. Bookseller Inventory # NU-LSI-06997831

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 43.13
Convert Currency

Add to Basket

Shipping: US$ 3.88
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Published by McGraw-Hill/OsborneMedia (2017)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Paperback Quantity Available: 10
Print on Demand
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill/OsborneMedia, 2017. Paperback. Book Condition: New. This item is printed on demand. Bookseller Inventory # 0072125667

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 44.21
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

7.

Dejan Sunderic
Published by McGraw-Hill Education - Europe (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Quantity Available: > 20
Print on Demand
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, 2000. PAP. Book Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # IQ-9780072125665

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 38.69
Convert Currency

Add to Basket

Shipping: US$ 11.68
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

ISBN 10: 0072125667 ISBN 13: 9780072125665
New Quantity Available: > 20
Print on Demand
Seller
BWB
(Valley Stream, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: New. This item is Print on Demand - Depending on your location, this item may ship from the US or UK. Bookseller Inventory # POD_9780072125665

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 52.47
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

9.

Dejan Sunderic
Published by McGraw-Hill Education - Europe, United States (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2000. Paperback. Book Condition: New. 234 x 190 mm. Language: English . Brand New Book ***** Print on Demand *****. This is a guide to building and using stored procedures in SQL server applications. Stored procedures are used for a variety of complex data gathering tasks, to optimize performance. Bookseller Inventory # APC9780072125665

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 53.45
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Dejan Sunderic
Published by McGraw-Hill Education - Europe, United States (2000)
ISBN 10: 0072125667 ISBN 13: 9780072125665
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2000. Paperback. Book Condition: New. 234 x 190 mm. Language: English . Brand New Book ***** Print on Demand *****.This is a guide to building and using stored procedures in SQL server applications. Stored procedures are used for a variety of complex data gathering tasks, to optimize performance. Bookseller Inventory # APC9780072125665

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 55.04
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book