SQL Server - After trigger

GeekInterview.com > Interview Questions > Database > SQL Server

Go To First | Previous Question | Next Question

SQL Server | Question 92 of 99

After trigger

Is there any reason for which we cannot use After trigger with a view?

Total Answers and Comments: 3

Last Update: September 04, 2009 Asked by: Minakshi Sur

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 18, 2008 06:58:10

kumar2ch

Member Since: June 2008 Contribution: 3

RE: After trigger

after trigger is used for complex views

Is this answer useful? Yes | No

March 11, 2009 19:14:19

sumit.sps

Member Since: March 2009 Contribution: 1

RE: After trigger

It is a specialized stored procedure that is executed when data in the table associated with trigger is modified. After trigger executes the code associated with it after the event for which it is made happens. For ex:- if after trigger is written for raising a message after DML operations is being performed it will allow that operation to be performed and will then display the message.

create trigger trigname

on database

for insert

begin

print'message'

end

Is this answer useful? Yes | No

September 04, 2009 03:51:33

pprasad_ktda

Member Since: September 2009 Contribution: 1

RE: After trigger

In a view if composite primary key is present than After Trigger cannot be defined.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank