J
J
jrtumgg2021-01-19 11:48:30
SQL Server
jrtumgg, 2021-01-19 11:48:30

How to write a DML trigger for a table?

There is a table Employees (No., Full Name, No. of Department, No. of Head). How to create an INSTEAD OF UPDATE trigger on a table? The trigger should prohibit changing the Manager's ID if the manager and the employee do not have the same Department ID. The trigger must change the Department No. of all subordinate records for the changed

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question