Guide
t-sql-and-triggers.md
Stored procedures, T-SQL programming, validation logic, and trigger exercises.
markdown
Advanced SQL: T-SQL and Triggers
This page focuses on the T-SQL programming side of the Database II repository.
Repository
- DataBase-Level2-SQL - Includes stored procedures, flow control, trigger exercises, and indexing tasks.
Main Sections
- Indexes and access plans
- T-SQL variable work and control flow
- Stored procedure exercises
- T-SQL evaluation
- Trigger activity
Representative Links
- Key Lookup exercise
- Control-flow notes
- Stored procedure for averages
- Prova T-SQL exercise 5
- Trigger log table exercise
Technical Focus
- Stored procedures
- Flow control in SQL
- Query optimization and indexing
- Trigger-based business rules