Acknowledgments.

PART I: SQL Server Programming Environment.

Chapter 1: Introduction to the SQL Server Programming Environment.

Chapter 2: Using the SQL Server Tools.

Chapter 3: Understanding SQL Server Security.

PART II: The Transact-SQL Language.

Chapter 4: Introduction to Transact-SQL.

Chapter 5: Using the Data Definition Language.

Chapter 6: Using the Data Manipulation Language.

Chapter 7: Exploring Transact-SQL Functions.

Chapter 8: Grouping and Totaling.

Chapter 9: Exploring Joins, Subqueries, and Unions.

Chapter 10: Building and Using Views.

Chapter 11: Working with Text and Images.

Chapter 12: Using the CUBE and ROLLUP Operators.

Chapter 13: Introduction to Cursors.

Chapter 14: Transact-SQL for Administrators.

Chapter 15: Working with Stored Procedures and Triggers.

Chapter 16: Exploring Transactions.

Chapter 17: Monitoring SQL Server Events.

PART III: SQL Server Programming.

Chapter 18: DB-Library.

Chapter 19: Open Database Connectivity.

Chapter 20: ActiveX Data Objects.

Chapter 21: Open Data Services.

PART IV: Appendixes.

Appendix A: What's on the CD-ROM?

Appendix B: The FundAccts Sample Database.

Appendix C: SQL Server SET Statements.

Appendix D: Functions.

Appendix E: Reserved Keywords.

Appendix F: System Stored Procedures.

Appendix G: SQL Server Databases and Tables.

Appendix H: Operators Reference.

Appendix I: Data Types Reference.

Appendix J: SQL Server 7.0 Technical Specifications.

Appendix K: sp_configure and sp_dboption Settings.

Appendix L: Files and File Locations.

Appendix M: Using the Data Transformation.

Services Wizards.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.