kumar2ch

 Profile Answers by kumar2ch 

• Jul 18th, 2008

 

after trigger is used for complex views

sumit.sps

 Profile Answers by sumit.sps 

• Mar 11th, 2009

 

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 

as

begin

print'message'

end

pprasad_ktda

 Profile Answers by pprasad_ktda 

• Sep 4th, 2009

 

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

psingla

 Profile Answers by psingla Questions by psingla

• Mar 16th, 2010

 

A after trigger gets fired whenever there is any insert/update/delete happens in the table on which the trigger is defined.
But the view is just a definition rather than an actual table so insert/update/delete does not actually happens on views.
If any of the (insert/update/delete) is used with the views than the data is stored in the actual tables rather than in views.