Microsoft SQL Server 2008 Bible
Chapter 4: Creating RDBMS Objects
- Listing 4-1: Default (NO ACTION) option
- Listing 4-2: CASCADE option
- Listing 4-3: Using deferrable constraints
Chapter 5: Altering and Destroying RDBMS Objects
- Oracle 9i
- DB2 UDB 8.1
- MS SQL Server 2000
- Oracle 9i
- DB2 UDB 8.1
Chapter 9: Multitable Queries
- SQL99 standard syntax
- Old syntax
- Syntax for right outer join
- Syntax for left outer join
- Syntax for right outer join
- Syntax for left outer join
Chapter 14: Stored Procedures, Triggers, and User-Defined Functions
- PL/SQL
- DB2 UDB
- Transact-SQL
- SQL99
- PL/SQL
- DB2 procedural language
- Transact-SQL
- SQL99
- PL/SQL
- DB2 procedural language
- Transact-SQL
Chapter 15: Dynamic and Embedded SQL Overview
- Example 1
- Example 2
- Example 3
- Oracle example
- DB2 UDB example
- C
- COBOL
- C
- COBOL
- C
- COBOL
- C
- COBOL
- C
- COBOL
- C
- COBOL
- C
- COBOL
- PREPARE
- EXECUTE
- C
- COBOL
- C
- COBOL
Appendix H: SQL Syntax Reference
- "New" syntax (inner join)
- "New" syntax (outer join)
- "Old" syntax (inner join)