i think we did 't call trigger into sp

Posted by Jameschowdare under Sql Server on 12/7/2009 | Views : 2284 | Status : [Member] | Replies : 7

Reply | Reply with Attachment

Posted by: Vuyiswamb on: 12/7/2009 [Member] [MVP] [Administrator] NotApplicable

0	What is your Question ? Thank you for posting at Dotnetfunda [Administrator] Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhi2434 on: 12/7/2009 [Member] [Microsoft_MVP] [MVP] Silver

0	Yes.. Triggers are automatically called whenever some DML operation is executed. We dont call it directly, but even if the DML operation is performed within an SP, the trigger block will be executed. www.abhisheksur.com Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhilan on: 12/8/2009 [Member] Starter

0	we can call triggers in SP Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 12/8/2009 [Member] [MVP] [Administrator] NotApplicable

0	Triggers cannot be called Directly. They are in table level, when certain operations happen like Update , delete they get executed. they can delete, Update and more. Thank you for posting at Dotnetfunda [Administrator] Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Chikul on: 12/10/2009 [Member] Bronze

0	No, Triggers can't call directly. Triggers will be fired(Executed) automatically when ever any DML Command like (Insert,Update or Delete) operation is executed on a particular table or view in a database. Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Abhi2434 on: 12/11/2009 [Member] [Microsoft_MVP] [MVP] Silver

0	Why the same answer is repeated for several times .. ?? www.abhisheksur.com Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Vuyiswamb on: 12/11/2009 [Member] [MVP] [Administrator] NotApplicable

0	Where did you see that ? Thank you for posting at Dotnetfunda [Administrator] Jameschowdare, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts