an after trigger for the update is created on the employeetable. the employee table has 10 rows. in update statement thatupdates five rows in the table is run. what is the correctstatement?
a. inside the trigger there are 5 rows in teh DELETED table, andother virtual tables are empty
b. inside the trigger there are 5 row in the INSERTED table, andother virtual tables are empty
c. inside the trigger there are 5 toes in the UPDATED table, andother virtual tables are empty
d. none of the above
Solution
c. inside the trigger there are 5 toes in the UPDATED
OR
OR