Machine-translated by Google. Questions are authored in English.
Top

Discussion

SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

  • A.True
  • B.False

Answer: B

Correct answer: False

SQL Server supports INSTEAD OF and AFTER triggers only; there is no BEFORE trigger. Much of what a BEFORE trigger does elsewhere is achieved with an INSTEAD OF trigger, which replaces the statement entirely and can perform whatever checks are wanted before writing the change itself.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.