Home › Forums › MS SQL Server

Can a trigger test a value in the record being inserted, updated, or deleted?

Hi Mike,

Is there a way to create a trigger which tests the value of a record being inserted, updated, or deleted?

For instance, a trigger is to test the length of an ISBN value being inserted into a table. A warning message should be printed if it is less than 10 characters.

Thanks,
Scott Brush

‹ Adding images (or other binary files) to the database directly Function for adding durations with the TIME data type ›
Sat, 08/20/2011 - 12:28 — m_sabal

Yes, but...

This is possible. You would use the 'inserted' view to check the value, and a rollback transaction command to prevent the errant data from being added to the table. However, most people will use the check constraint to keep the data consistent, and will handle error reporting in their application.