Vieira, Robert
Professional SQL server 2000 programming. / Robert Vieira - Birmingham: Wrox press ltd; 2000. - xxiii, 1390p. : ill. 25cm
Includes index.
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 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.
1861004486
QA76.9. D3 V525
Professional SQL server 2000 programming. / Robert Vieira - Birmingham: Wrox press ltd; 2000. - xxiii, 1390p. : ill. 25cm
Includes index.
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 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.
1861004486
QA76.9. D3 V525