A trigger is used for executing the batch of MsSQL codes. This is done when commands like INSERT, UPDATE or DELETE are executed against a sequence of the table. Whenever the data gets modified this command automatically gets triggered.

Its types are-
  • INSERT
  • UPDATE
  • INSTEAD OF
  • DELETE
BY Best Interview Question ON 17 Oct 2019