| Introduction | p. 1 |
| Who Should Read This Book | p. 3 |
| What You Will Find in This Book | p. 3 |
| Requirements | p. 5 |
| Sample Database and Other Resources | p. 6 |
| The SQL Server Environment | p. 19 |
| SQL Server 2000 Tools | p. 20 |
| Basic Operations with Stored Procedures | p. 31 |
| Naming Conventions | p. 44 |
| Stored Procedure Design Concepts | p. 53 |
| Anatomy of a Stored Procedure | p. 54 |
| Types of Stored Procedures | p. 65 |
| Compilation | p. 67 |
| Managing Stored Procedures | p. 74 |
| The Role of Stored Procedures in the Development of Database Applications | p. 82 |
| Basic Transact-SQL Programming Constructs | p. 85 |
| T-SQL Identifiers | p. 86 |
| Database Object Qualifiers | p. 88 |
| Data Types | p. 89 |
| Variables | p. 99 |
| Flow-Control Statements | p. 107 |
| Cursors | p. 121 |
| Functions | p. 131 |
| Using Functions | p. 132 |
| Types of Functions | p. 135 |
| Composite Transact-SQL Constructs: Batches, Scripts, and Transactions | p. 169 |
| Batches | p. 170 |
| Scripts | p. 179 |
| Transactions | p. 182 |
| Debugging and Error Handling | p. 207 |
| Debugging | p. 208 |
| Error Handling | p. 235 |
| Special Types of Procedures | p. 259 |
| Types of Stored Procedures | p. 260 |
| User-Defined Functions | p. 271 |
| Triggers | p. 283 |
| Views | p. 311 |
| Advanced Stored Procedure Programming | p. 341 |
| Dynamically Constructed Queries | p. 342 |
| Optimistic Locking Using timestamp Values | p. 356 |
| Full-Text Search and Indexes | p. 363 |
| Nested Stored Procedures | p. 365 |
| Using Identity Values | p. 378 |
| GUIDs | p. 381 |
| A While Loop with Min() or Max() Functions | p. 383 |
| Looping with sp_MSForEachTable and sp_MSForEachDb | p. 385 |
| Property Management | p. 386 |
| Interaction with the SQL Server Environment | p. 389 |
| Execution of OLE Automation/COM Objects | p. 390 |
| Running Programs | p. 394 |
| Running Windows Script Files | p. 395 |
| Running/Looping Through DTS Packages | p. 395 |
| Interacting with the NT Registry | p. 398 |
| Jobs | p. 400 |
| SQL Server and the Web | p. 407 |
| E-Mail | p. 415 |
| Security | p. 419 |
| Source Code Management and Database Deployment | p. 437 |
| The Concept of Source Code Management | p. 438 |
| Database Deployment | p. 453 |
| Stored Procedures for Web Search Engines | p. 467 |
| Characteristics of the Environment | p. 468 |
| A Simple Solution... | p. 468 |
| ...and Its Disadvantages | p. 470 |
| Available Solutions | p. 471 |
| Introduction to XML for Database Developers | p. 489 |
| XML (R)evolution | p. 490 |
| Introduction to XML | p. 492 |
| XML Document Quality | p. 501 |
| Linking and Querying in XML | p. 518 |
| Transforming XML | p. 522 |
| Why XML? | p. 524 |
| Publishing Information Using SQLXML | p. 527 |
| For XML Clause | p. 528 |
| Publishing Database Information Using HTTP | p. 547 |
| Programmatic Database Access | p. 588 |
| Retrieving XML Data Using ADO.NET | p. 597 |
| Client-Side XML Processing | p. 599 |
| Modifying Databases Using SQLXML | p. 605 |
| OpenXML() | p. 606 |
| UpdateGrams | p. 615 |
| DiffGrams | p. 628 |
| SQLXML BulkLoad | p. 639 |
| XML Web Services | p. 647 |
| T-SQL and XML Data Types in SQL Server 2000 | p. 659 |
| Index | p. 669 |
| Table of Contents provided by Ingram. All Rights Reserved. |