SQL Server 2000 Developer's Guide - Softcover

Otey, Michael; Conte, Paul

Softcover

ISBN 10: 0072125691 ISBN 13: 9780072125696

Publisher: McGraw-Hill Osborne Media, 2000

Synopsis

"A great reference on SQL Server 2000, loaded with excellent code examples." --Sean O'Farrell, Manager, Business Integration, Eli Lilly and Company This book includes full coverage of Transact-SQL's DDL, and DML as well as ADO, DAO, and RDO. You'll learn to build scaleable SQL Server 2000 Web solutions and handle database management, backup, recovery, and security.

About this title

About the Author

Michael Otey (Portland, OR) is a Senior Technical Editor of SQL Server Magazine and Windows NT Windows Magazine. He is also the presient of TECA, a consulting and software development company. Paul Conte (Eugene, OR)is an established database expert and author of many books. He is also the president of Picante Software.

From the Back Cover

Build powerful, enterprise-wide database applications

SQL Server 2000 Developer's Guide explains how to access and manipulate data using Transact-SQL, build powerful Windows applications with ADO, DAO, and RDO, and develop integrated, cross-platform Web applications with ASP and XML. You'll also get details on SQL Server 2000 management, administration, and security issues. Plus, the bonus CD-ROM contains ready-to-run code and an evaluation edition of SQL Server 2000. This in-depth guide is a must-have for all serious SQL Server 2000 application developers.

• Master Transact-SQL's Data Definition Language (DDL) and Data Manipulation Language (DML)
• Accomplish complex data retrieval and manipulation tasks
• Write stored procedures, triggers, and functions to increase application functionality and simplify development
• Develop database applications using Visual Basic, ActiveX Data Objects (ADO), Data Access Objects (DAO), and Remote Database Objects (RDO)
• Build data-driven Web applications with Active Server Pages
• Create cross-platform data transfer applications using XML
• Develop custom SQL Server management applications with SQL-Distributed Management Objects (DMO)
• Transfer objects and data between systems using SQL Server's Data Transformation Services (DTS)
• Expand application capabilities with SQL Server's full-text search and English Query features
• Plan and implement enterprise-wide security, backup, and restore procedures
• Includes SQL Server 2000 120-Day Enterprise Evaluation Edition on CD

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2000
• ISBN 10: 0072125691
• ISBN 13: 9780072125696
• Binding: Paperback
• Language: English
• Edition number: 2
• Number of pages: 1248