What is Trigger in Sql Server?

Anonymous User 1374 31 Jul 2018

Please Give me a suitable Example.

1 Answers

Anonymous User 31 Jul 2018

A trigger is a special type of a stored procedure that’s rise in the response at the certain action on the table like insert, update, and delete of data. It is executed automatically. You can’t explicitly invoke triggers. The only way to do this is by performing the required action on the table that they are assigned to.

Example:-

CREATE TRIGGER Delete_Products

ON Product

Instead Of

Delete

AS

Print  “You are Not Allowed to delete Record”.

-------------

Create Trigger Insert_Products

ON Products

AFTER

INSERT

AS

PRINT   “Record Inserted in the Products table”

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

What is Trigger in Sql Server?

Can you answer this question?

1 Answers