Read more
Provides a guide to programming with SQL Server 2000, from a tutorial on Transact-SQL to a discussion of features, such as indexed views, user-defined functions, and the SQL Server features to support XML. Database administration is also covered, but only as it affects the SQL Server developer. This book is intended for the SQL Server developer.
List of contents
Introduction.
Chapter 1. SQL Server 2000 - Particulars and History.
Chapter 2. RDBMS Basics: What Makes Up a SQL Server Database?.
Chapter 3. Tools of the Trade.
Chapter 4. The Foundation Statements of T-SQL.
Chapter 5. Joining Tables.
Chapter 6. Creating and Altering Tables.
Chapter 7. Constraints.
Chapter 8. Normalization and Other Basic Design Issues.
Chapter 9. SQL Server Storage and Index Structures.
Chapter 10. Views.
Chapter 11. Writing Scripts and Batches.
Chapter 12. Stored Procedures.
Chapter 13. User Defined Functions.
Chapter 14. Transactions and Locks.
Chapter 15. Triggers.
Chapter 16. Advanced Queries.
Chapter 17. Distributed Queries and Transactions.
Chapter 18. SQL Cursors.
Chapter 19. A Brief XML Primer.
Chapter 20. Integration of XML into SQL Server.
Chapter 21. The Bulk Copy Program (bcp).
Chapter 22. Introduction to Data Transformation Services.
Chapter 23. Replication.
Chapter 24. Advanced Design.
Chapter 25. Analysis Services.
Chapter 26. Full-Text Search.
Chapter 27. English Query.
Chapter 28. Security.
Chapter 29. Performance Tuning.
Chapter 30. Administration Overview.
Chapter 31. Advanced DTS.
Chapter 32. Scripting Administrative Functions with WMI.
Appendix A. System Functions.
Appendix B. Function Listing.
Appendix C. Tools for Our Time.
Appendix D. Access Upsizing.
Appendix E. Microsoft Data Transformation Services Package Object Library Reference
Index.
