| |
| |
| |
| Introduction | |
| |
| |
| Who Should Read This Book | |
| |
| |
| What You Will Find in This Book | |
| |
| |
| Requirements | |
| |
| |
| Sample Database and Other Resources | |
| |
| |
| |
| The SQL Server Environment | |
| |
| |
| SQL Server 2000 Tools | |
| |
| |
| Basic Operations with Stored Procedures | |
| |
| |
| Naming Conventions | |
| |
| |
| |
| Stored Procedure Design Concepts | |
| |
| |
| Anatomy of a Stored Procedure | |
| |
| |
| Types of Stored Procedures | |
| |
| |
| Compilation | |
| |
| |
| Managing Stored Procedures | |
| |
| |
| The Role of Stored Procedures in the Development of Database Applications | |
| |
| |
| |
| Basic Transact-SQL Programming Constructs | |
| |
| |
| T-SQL Identifiers | |
| |
| |
| Database Object Qualifiers | |
| |
| |
| Data Types | |
| |
| |
| Variables | |
| |
| |
| Flow-Control Statements | |
| |
| |
| Cursors | |
| |
| |
| |
| Functions | |
| |
| |
| Using Functions | |
| |
| |
| Types of Functions | |
| |
| |
| |
| Composite Transact-SQL Constructs: Batches, Scripts, and Transactions | |
| |
| |
| Batches | |
| |
| |
| Scripts | |
| |
| |
| Transactions | |
| |
| |
| |
| Debugging and Error Handling | |
| |
| |
| Debugging | |
| |
| |
| Error Handling | |
| |
| |
| |
| Special Types of Procedures | |
| |
| |
| Types of Stored Procedures | |
| |
| |
| User-Defined Functions | |
| |
| |
| Triggers | |
| |
| |
| Views | |
| |
| |
| |
| Advanced Stored Procedure Programming | |
| |
| |
| Dynamically Constructed Queries | |
| |
| |
| Optimistic Locking Using timestamp Values | |
| |
| |
| Full-Text Search and Indexes | |
| |
| |
| Nested Stored Procedures | |
| |
| |
| Using Identity Values | |
| |
| |
| GUIDs | |
| |
| |
| A While Loop with Min() or Max() Functions | |
| |
| |
| Looping with sp_MSForEachTable and sp_MSForEachDb | |
| |
| |
| Property Management | |
| |
| |
| |
| Interaction with the SQL Server Environment | |
| |
| |
| Execution of OLE Automation/COM Objects | |
| |
| |
| Running Programs | |
| |
| |
| Running Windows Script Files | |
| |
| |
| Running/Looping Through DTS Packages | |
| |
| |
| Interacting with the NT Registry | |
| |
| |
| Jobs | |
| |
| |
| SQL Server and the Web | |
| |
| |
| E-Mail | |
| |
| |
| Security | |
| |
| |
| |
| Source Code Management and Database Deployment | |
| |
| |
| The Concept of Source Code Management | |
| |
| |
| Database Deployment | |
| |
| |
| |
| Stored Procedures for Web Search Engines | |
| |
| |
| Characteristics of the Environment | |
| |
| |
| A Simple Solution... | |
| |
| |
| ...and Its Disadvantages | |
| |
| |
| Available Solutions | |
| |
| |
| |
| Introduction to XML for Database Developers | |
| |
| |
| XML (R)evolution | |
| |
| |
| Introduction to XML | |
| |
| |
| XML Document Quality | |
| |
| |
| Linking and Querying in XML | |
| |
| |
| Transforming XML | |
| |
| |
| Why XML? | |
| |
| |
| |
| Publishing Information Using SQLXML | |
| |
| |
| For XML Clause | |
| |
| |
| Publishing Database Information Using HTTP | |
| |
| |
| Programmatic Database Access | |
| |
| |
| Retrieving XML Data Using ADO.NET | |
| |
| |
| Client-Side XML Processing | |
| |
| |
| |
| Modifying Databases Using SQLXML | |
| |
| |
| OpenXML() | |
| |
| |
| UpdateGrams | |
| |
| |
| DiffGrams | |
| |
| |
| SQLXML BulkLoad | |
| |
| |
| XML Web Services | |
| |
| |
| |
| T-SQL and XML Data Types in SQL Server 2000 | |
| |
| |
| Index | |