SQL Scripts / Code

Medical Selects (2023)

Examples of a SELECT with a sub-query to test/search for a specific line of text.

Updates with Rollback (2023)

Examples of UPDATE queries wrapped in Transaction statements with Rollbacks.

Various Joins (2023)

Examples of several queries using JOIN to find answer text.

Stored Procedures (2025)

Examples of several Stored Procedures used as a concept only.

User-Defined Functions (2025)

Examples of several User-Defined Functions used as a concept only.

Case Statement (2025)

An example of several Case statements used as a concept only.