Chapter 1. Datatype-Related Problems, XML, and CLR UDTs
DATETIME Datatypes
Character-Related Problems
Large Objects
Implicit Conversions
CLR-Based User-Defined Types
XML Data Type
Conclusion
Chapter 2. Temporary Tables and Table Variables
Temporary Tables
Table Variables tempdb Considerations
Table Expressions
Comparison Summary
Summary Exercise—Relational Division
Conclusion
:: Course ::
Chapter 3. Cursors
Using Cursors
Cursor Overhead
Dealing with Each Row Individually
Order-Based Access
Conclusion
Chapter 4. Dynamic SQL
EXEC sp_executesql
Environmental Settings
Uses of Dynamic SQL
SQL Injection
Conclusion
Chapter 5. Views
What Are Views?
ORDER BY in a View
Refreshing Views
Modular Approach
Updating Views
View Options
Indexed Views
Conclusion
:: Course ::
Chapter 6. User-Defined Functions
Some Facts About UDFs
Scalar UDFs
Table-Valued UDFs
Per-Row UDFs
Conclusion
Chapter 7. Stored Procedures
Types of Stored Procedures
The Stored Procedure Interface
Resolution
Compilations, Recompilations, and Reuse of Execution Plans
EXECUTE AS
Parameterizing Sort Order
Dynamic Pivot
CLR Stored Procedures
Conclusion
Chapter 8. Triggers
AFTER Triggers
INSTEAD OF Triggers
DDL Triggers
CLR Triggers
Conclusion
Download Chapter
:: Course ::
Chapter 9. Transactions
What Are Transactions?
Locks
Isolation Levels
Save Points
Deadlocks
Conclusion
Chapter 10. Exception Handling
Exception Handling Prior to SQL Server 2005
Exception Handling in SQL Server 2005
Conclusion
Chapter 11. Service Broker
Dialog Conversations
Sample Dialog
Dialog Security
Routing and Distribution
Scenarios
Where Does Service Broker Fit?
Conclusion
:: Course ::
Appendix A. Companion to CLR Routines
Create the CLRUtilities Database: SQL Server
Development: Visual Studio
Deployment and Testing: Visual Studio and SQL Server
About the Contributors
Itzik Ben-Gan
Dejan Sarka
Roger Wolter
Steve Kass
Lubor Kollar
Index
Programme scope, delivery arrangements and suitability are confirmed during enquiry.