Select from following answers:- SELECT COUNT(*) FROM Inserted

- SELECT * FROM Inserted
- SELECT COUNT(*) FROM Deleted
- All Above
You can use the SELECT COUNT(*) FROM Inserted statement in a trigger to determine the number of rows that have been inserted.
You should not use the SELECT * FROM Inserted statement. This statement selects all content in the Inserted table, but it does not count the rows. You are interested in the number of rows in the Inserted table.
Show Correct Answer
Source: Microsoft Press book | |
Alert Moderator