forum

home / developersection / forums / what is trigger in sql server?

Ask Question

What is Trigger in Sql Server?

Anonymous User 1210 31-Jul-2018

Please Give me a suitable Example.

mssql server

Updated on 31-Jul-2018

Anonymous User

A_Philosopher

I am a content writter !

Message

Can you answer this question?

Answer

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”

forum

What is Trigger in Sql Server?

Anonymous User

Can you answer this question?

1 Answers

Liked By