Hello Friend Today We Are talking about After Trigger.After Trigger is use for insert,update delete operation
1)After Trigger(using FOR/AFTER CLAUSE) :
for example we fire one statement on the table after execute that statement trigger is effect into another table that is called after trigger.
After Insert Trigger
now try to insert data into dbo.a_student_info
insert into a_student_detail(s_name,s_std,s_school_name)values('Devid',8,'DPS School');
after insert data into a_student_detail trigger is automatically fire and as per mention in trigger trigger is insert record into dbo.a_student_fees_info automatically.
now try to update record of dbo.a_student_info
Now to try to delete data from dbo.a_student_detail
After Update Trigger
now try to update record of dbo.a_student_info
update a_student_info set s_name='Martin',s_std=8,s_school_name='Gurukul High School' where PK_s_id=1;after update data into a_student_detail trigger is automatically fire and as per mention in trigger trigger is update record into dbo.a_student_fees_info automatically.
After Delete Trigger
Now to try to delete data from dbo.a_student_detail
Delete From a_student_info where PK_s_id=2
after Delete data into a_student_detail trigger is automatically fire and as per mention in trigger trigger is Delete record into dbo.a_student_fees_info automatically.
