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

Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial