SQL-Server Triggers  «Prev  Next»

Creating SQL Triggers - Exercise

Creating Triggers Exercise in SQL Server 2022

Objective:Practice creating a trigger.

Exercise scoring

This exercise is worth a total of 20 points.
You will receive 20 points for accurately creating the Transact-SQL statement that creates a trigger, described in the instructions.


Construct a trigger, named trgDelete, that is affected only by DELETE Transact-SQL statements in the Sales table. This trigger should simply raise an error that indicates that data cannot be deleted from this table.

Submitting the exercise

Type or paste your Transact-SQL statement into the text box below, then click Submit to submit it and view a results page.