SQL-Server Triggers  «Prev 
save-transaction-syntax.php

Issue Transact SQL Statement

The statement inserts a salary that is less than $150,000 and should be allowed.
1) The statement insert a salary that is less than $150,000 and should be allowed.

This statement inserts a salary that is higher than $150,000, without an approal. This statement should not be allowed.
2) This statement inserts a salary that is higher than $150,000, without an approal. This statement should not be allowed.

This statement inserts a salary that is higher than $150,000, with approval and should be allowed.
3) This statement inserts a salary that is higher than $150,000, with approval and should be allowed.