This post explores Cursor and Trigger in SQL with practical examples in a way that’s easy to understand.
This post explores Cursor and Trigger in SQL with practical examples in a way that’s easy to understand.
Cursor — Processing Rows with a Condition
A cursor allows you to process query results row by row, especially when you need to apply logic or conditions that can’t be handled by a single SQL statement.
Objective
Display employee names whose salary is greater than 50,000 using a cursor.
Trigger — Automating an Action After INSERT
A trigger automatically executes a set of SQL statements when a specific database event (like INSERT, UPDATE, or DELETE) occurs.
Here, we’ll use an AFTER INSERT trigger to maintain a student registration log.
Objective
Whenever a new record is added to the Students table, automatically insert an entry into the Student_Audit table.
**Testing the Trigger
**
When a new student record is inserted, the trigger automatically creates a log entry in the Student_Audit table.
Summary
✔ Cursor – Processes data row by row for conditional operations.
✔ Trigger – Automates database actions after an event.
Both help make SQL more dynamic, controlled, and responsive to real-time data changes.
Top comments (0)