SQL Server 2000 Developer's Guide

• 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
• OLE DB, ActiveX Data Objects (ADO),
• Data Access Objects (DAO), and Remote
• Database Objects (RDO)
• Build data-driven Web applications with
• Active Server Pages (ASP) and ADO
• Create integrated cross-platform Web applications using XML
• Develop custom SQL Server management applications with SQL-Distributed Management Objects (SQL-DMO)
• Transfer objects and data between systems using SQL Server's Data Transformation Services (DTS)
• Add English Query and Full-Text Search capabilities to your database applications Plan and implement enterprise-wide security, backup, and restore procedures

Contents

Introduction.

Chapter 1: Introduction to SQL Server 2000.

Part I: Mastering T-SQL.

Chapter 2: Database Definition Basics.

Chapter 3: Database Definition Advanced.

Chapter 4: Data Manipulation Basics.

Chapter 5: Advanced Statement Features.

Chapter 6: Writing Stored Procedures and Triggers.

Chapter 7: Extended Stored Procedures.

Part II: Windows Applications.

Chapter 8: Using ActiveX Data Objects.

Chapter 9: Using ODBC.

Chapter 10: Using Database Access Objects (DAO).

Chapter 11: Using ODBCDirect.

Chapter 12: Using Remote Data Objects (RDO).

Chapter 13: Using DB Library.

Part III: Web Applications.

Chapter 14: Integrating SQL Server and IIS for Web/Database Development.

Chapter 15: Using Active Server Pages (ASP).

Chapter 16: Using the SQL Server Web Wizard.

Part IV: Desktop Applications.

Chapter 17: Development Using Access 2000.

Chapter 18: Development Using Excel 2000.

Part V: Management, Replication and Analysis Applications.

Chapter 19: SQL-DMO.

(and more...)