* Shows you how to write more effective stored procedures and functions * Concise, detailed advice from SQL Server experts * Tackles issues barely covered in existing books, such as optimizing and debugging, concurrency and transactions.

SQL Server 2000 Stored Procedures Handbook (Expert's Voice)

Computers & Technology

Robin Dewson

Davidson, Louis

Dewson, Robin

Bain, Tony

Hawkins, Chuck

Tony Bain

Louise Davidson

Chuck Hawkins

Programming

Apress

*The first edition of this book is well respected in the programming community; received all five-star reviews. *C# database programming is a leading area of book sales; this edition fully updated for .NET 1.1 and ADO. *Leads readers from beginning topics, to acquiring skills they’ll need in their C# programming careers. Plus, current wave of C# adoption in programming community, especially from programmers using VB6―this book is suited for such new readership.

Beginning C# Databases: From Novice to Professional

Scott, Allen

Jacob Hammer Pedersen

Jon Reid

Syed Fahad Gilani

James Huddleston

Ranga Raghuram

* First book to provide comprehensive, deeply practical coverage on all major new SS2005 features. • Lead author (Tom Rizzo) is a key member of the SQL Server team at Microsoft and a respected author and blogger. • Gets the DBA and developer up and running with SS2005 in the fastest possible time. • The facts, not the evangelism.

Pro SQL Server 2005

Thomas Rizzo

Adam Machanic

Rob Walters

Joseph Sack

Julian Skinner

Louis Davidson

Networking & Cloud Computing

Microsoft SQL Server 2000 is the latest and most powerful version of a product that provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications. 
Beginning SQL Server 2000 Programming develops an example database, at every point providing clear and practical demonstrations of the relevant ideas. Once you have mastered the basics of SQL Server, this book will take you on to more advanced techniques to enable a firm grasp of the most important features quickly and easily, in order to develop your own effective database solutions straight away. 
Included with this book is a 120-day Enterprise Evaluation edition of Microsoft SQL Server 2000. An end user license agreement is contained in this licensed software. 
This book covers: Choosing and installing the correct version of SQL Server 2000 The important tools used as an interface to SQL Server 2000 Basics of relational database design Building the sample database for the book Creating and deleting databases, tables, relationships, and indexes with the interactive tools of SQL Server, and through the Transact-SQL language Maintaining, inserting, retrieving, and updating data Managing transactions to safeguard data modifications Using stored procedures to control the flow of execution of SQL statements Using XML to retrieve data from SQL Server and publish this data to the Internet Creating triggers to ensure data integrity Includes 120-Day Enterprise Evaluation Edition of Microsoft SQL Server 2000

Beginning SQL Server 2000 Programming

Explains how to create applications for Windows Services using Visual Basic, discusses the use of the System.ServiceProcess namespace, and demonstrates how to improve scalability.

Visual Basic .Net Windows Services Handbook

Brian Patterson

Bill Sempf

Richard Conway

Operating Systems

If you want to write better stored procedures, this is the book for you. 
This book will tackle real-world problems faced by developers when working with stored procedures, showing how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. 
This book is for the SQL Server 2000 developer, who wants a book that starts where books like Rob Viera's Professional SQL Server 2000 Programming finish. 
Topics covered include: 
 Typical uses and misuses of stored procedures Debugging and optimizing stored procedures System stored procedures and extended stored procedures Cursors, transactions and concurrency Working with triggers User defined functions Stored procedures and security

SQL Server 2000 Stored Procedure Handbook

See the best price to sell, buy, or rent books by Robin Dewson. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Robin Dewson