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
Robin Dewson has been working with Wrox Press for over two years now as a technical reviewer and recently was invited to provide additional material for Professional Access 2000, Professional Access with SQL Server 2000, Professional SQL Server with DTS and Professional SQL Server 2000. He has built up a good rapport with Wrox Press over this time and from his working experience was invited to write this book concerning SQL Server 2000.
Robin is currently consulting at Lehman Brothers in the City of London using Visual Basic 6 and Sybase on a trading system called Kojak, where he has been for nearly 5 years. When he has a spare moment, he is also beta testing .NET technologies and is looking forward to the next generation of technologies.