SQL Server 2000 Stored Procedure Programming Paperback - 2000
by Dejan Sunderic
- New
This book is an A-Z guide to building and using stored procedures in SQL Server applications. With this book, developers can custom design stored procedures to write high-performance SQL Server applications that effectively can be maintained and scaled. They also will learn to administer SQL Server environments using Microsoft's system stored procedures. 20 line illustrations.
Standard delivery: 2 to 14 days
Details
- Title SQL Server 2000 Stored Procedure Programming
- Author Dejan Sunderic
- Binding Paperback
- Edition [ Edition: first
- Condition New
- Pages 752
- Volumes 1
- Language ENG
- Publisher McGraw-Hill/Osborne Media
- Publication date 2000-10-02
- Illustrated Yes
- Features Illustrated
- Bookseller's Inventory # 82933-n
- ISBN 9780072125665 / 0072125667
- Weight 2.76 lbs (1.25 kg)
- Dimensions 9.24 x 7.36 x 1.59 in (23.47 x 18.69 x 4.04 cm)
- Category Computers - Data Base Management
- Library of Congress subjects Client/server computing, Relational databases
- Library of Congress Catalogue Number 00711269
- Dewey Decimal Code 005.758
- Quantity available 5
About GreatBookPrices Maryland, United States
Since 1991, we have worked every day to serve our customers with state-of-the-art technology and world class service. We are dedicated to providing customers around the world with the widest selection of books, DVDs, and CDs at the absolute lowest price.
Reader reviews for SQL Server 2000 Stored Procedure Programming
Write a review for this book
Important Terms and Guidelines
- Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
- Reviews must be at least 140 characters in length.
- Please do not reveal critical plot elements.
- This is not a help line. Contact customer support if you need help.
Your review must not include:
- Obscenities, discriminatory language, or other insulting language not suitable for public domain
- Advertisements, “spam” content, or references to other products, offers or websites.
- Email addresses, URLs, phone numbers, physical addresses or other contact information.
- Overly critical comments about other reviews or reviewers
- Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
- Availability, price, or alternative ordering/shipping information
From the publisher
First line
From the rear cover
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