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. |