Get startedGet started for free

Preventing changes to orders

Fresh Fruit Delivery needs to prevent changes from being made to the Orders table.

Any attempt to do so should not be permitted and an error should be shown instead.

This exercise is part of the course

Building and Optimizing Triggers in SQL Server

View Course

Exercise instructions

  • Create a new trigger on the Orders table.
  • Set the trigger to prevent updates and return an error message instead.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Create the trigger
___ ___ PreventOrdersUpdate
ON ___
___ ___ UPDATE
AS
	RAISERROR ('Updates on "Orders" table are not permitted.
                Place a new order to add new products.', 16, 1);
Edit and Run Code