01646nam a22001337a 4500008004100000020001500041050002000056100001900076245006300095260004000158300003100198500002000229505126300249180417b xxu||||| |||| 00| 0 eng d a1861004486 aQA76.9. D3 V525 aVieira, Robert aProfessional SQL server 2000 programming. /cRobert Vieira aBirmingham:bWrox press ltd;c2000. axxiii, 1390p. : ill.c25cm aIncludes index. aContents: 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.