Research Catalog

Title

Professional SQL Server 2000 programming / Robert Vieira.

Author

Vieira, Robert

Publication

Birmingham, UK : Wrox Press, c2000.

Items in the Library & Off-site

Details

Description

xxiii, 1390 p. : ill.; 24 cm.

Series Statement

Programmer to programmer

Uniform Title

Programmer to programmer.

Alternative Title

SQL Server 2000 programming

Subject

• SQL server
• SQL (Computer program language)
• Database management

Note

• Includes index.

Processing Action (note)

• committed to retain

Contents

1. A Brief History Of Databases -- 2. Basic Objects in a SQL Server based relational database -- 3. Tools of The Trade -- 4. The Foundation Statements of SQL -- 5. Joining Tables -- 6. Creating and Altering Tables -- 7. Keys and Constraints -- 8. Normalization and Other Basic Design Issues -- 9. SQL Server Storage and Index Structures -- 10. Views -- 11. Writing Scripts and Batches -- 12. Stored Procedures -- 13. User Defined Functions -- 14. Transactions and Locks -- 15. Triggers -- 16. Advanced Query Topics -- 17. Distributed Transactions and Queries -- 18. SQL Cursors -- 19. XML -- 20. SQL Server and XML -- 21. The Bulk Copy Program -- 22. Beginning Data Transformation Services -- 23. Replication -- 24. Advanced Database Design -- 25. Analysis Services -- 26. Full Text Search -- 27. English Query -- 28. The Security Roundup -- 29. Performance Tuning -- 30. Administration Overview -- 31. Manipulating DTS using DSO -- 32. WMI.

ISBN

1861004486

OCLC

• 45660168
• SCSB-10233592

Owning Institutions

Harvard Library