How to write trigger in storeprocedure

for learning purpose how to use trigger that's why i am trying .

can possible write trigger in store proceduer then it is possible then how to write procedure

Hi Asim,

 

what is your exact requirement and why do you want to use trigger?

 

Usually, trigger is used to do some operation when any data is inserted/updated/deleted in a table. this operation can be on that table or any other table. you can call SP from a trigger.

 

But first you have to identify your logic. Remember trigger will be fired always e.g. if data is inserted from SP or directly using edit table data.

 

Be careful with triggers as sometimes it may get you performance headaches if so many triggers