Beginning SQL Server 2000 Programming

by Robin Dewson

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
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

800 pages, Paperback

First published June 1, 2001