With scalability for the most demanding applications, Microsoft® SQL Server™ 2000 can dramatically reduce the time needed to bring e-commerce, data warehousing, and line-of-business applications to market. Whether you’re new to databases or familiar with Microsoft Access, Oracle, and other relational databases, MICROSOFT SQL SERVER 2000 PROGRAMMING STEP BY STEP is the ideal way to learn how SQL Server can work for you. Written by an experienced database developer and author and replete with examples and exercises, this book will help you quickly get up to speed with creating and maintaining databases using the interactive tools provided by SQL Server 2000 Personal, Standard, and Enterprise Editions. It’s a must-have resource for anyone who wants to create and maintain databases and program with Transact-SQL.
This title shows you how to: Get started with SQL Server:
Use the Enterprise Manager to connect to a database; start, stop, and pause SQL Server
Back up and restore a database and use the Maintenance Plan Wizard to create a monthly backup plan and manage SQL Server security functions.
Create a SQL database: Create and manage databases, tables, indexes, relationships, constraints, table objects, and database diagrams.
Retrieve data: Retrieve rows, use the SELECT statement, join tables and summarize data, and view data in a variety of ways.
Work with data: Add, delete, and update rows, and import and export data.
Use the Transact-SQL programming language: Understand operators, variables, parameters, and control of flow
Use stored procedures; create and manage triggers
Learn error handling
Included on CD-ROM!
Sample database files
Sample script code in Transact-SQL
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to email@example.com.
Microsoft® SQL Server™ 2000 Programming Step by Step
With twenty years experience in the field, Rebecca M. Riordan has earned an international reputation for designing and implementing computer systems that are technically sound, reliable, and effectively meet her clients' needs. Her particular area of expertise is database design and she is a five year Access MVP. Rebecca has also authored several database books and served as a senior technical support engineer for Microsoft's database products. As a Microsoft employee in Australia, Rebecca was the Senior technical support engineer for Microsoft's database products.