Write a trigger for the Product table to ensure the list price can never be raised more than 15% in a single change. Modify the trigger from Exercise 1 to execute its check code only if the ListPrice column is updated.
This is the question for exercise 1:
Cause a deadlock using updates on Person.Person and Human Resources.Employee. You will have to run different queries in sequence within two transactions using at least two query windows within Management Studio to do this. Hint: If you BEGIN TRANSACTION within a query window, the transaction stays open until you COMMIT, ROLLBACK, or kill the connection.