SQL Server 2000 Developer's Guide

From the Publisher: "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. 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 tasksWrite 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 PagesCreate cross-platform data transfer applications using XMLDevelop 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 withSQL Server's full-text search and English Query featuresPlan and implement enterprise-wide security,backup,and restore proceduresIncludes SQL Server 2000 120-Day Enterprise Evaluation Edition on CD