List of Listings

Chapter 2. SQL Server tools for maintaining data integrity

Listing 1. Basic template for triggers

Listing 2. Trigger to ensure line item total > 0

Chapter 4. Set-based iteration, the third alternative

Listing 1. Set-based iteration with the TOP clause

Listing 2. Declarative code for calculating running totals

Listing 3. Iterative code for calculating running totals

Listing 4. Set-based iteration for calculating running totals

Listing 5. Set up tables and generate random data for bin packing

Listing 6. Iterative code for bin packing

Listing 7. Creating the numbers table for use in the set-based bin-packing code

Listing 8. Set-based iteration for bin packing

Chapter 5. Gaps and islands

Listing 1. Code creating and populating table NumSeq

Listing 2. Code creating and populating the BigNumSeq table

Listing 3. Gaps—solution 1 using subqueries

Listing 4. Gaps—solution 2 using subqueries

Listing 5. Gaps—solution 3 using ranking functions

Listing 6. Gaps—solution 4 using cursors

Listing 7. Islands—solution 1 using subqueries and ranking calculations

Listing 8. Islands—solution 2 using group identifier based on subqueries

Listing 9. Islands—solution 3 using group identifier based on ranking calculations

Listing 10. Islands—solution 4 using cursors

Listing 11. Code creating and populating table T1

Listing 12. Solution to variation on the islands problem

Chapter 6. Error handling in SQL Server and applications

Listing 1. Error sent to SQL Server Management Studio