Richard Campbell Blogs Too

I'm about to do my last session at Tech Ed Boston, a repeat of my session on Monday, SQL Querying Tips & Techniques.

I figure I better just put the session sample here, so you can download it if you're so inclined.

sample.zip (5.49 KB)

The following files are inside the sample zip:

• AdvQuerying_Setup.sql contains a script to create the tables and data for the samples
• AdvQuerying.sql is the script with all the example queries I demoed in the session
• Error Handling Main.sql is the script for the deadlock error handling stored proc
• Error Handlng Secondary.sql is the script for setting up the deadlock demo

So to use these samples, create a database (I called it AdvQuerying) and then run the setup script. Then you're good to go!