i think we did 't call trigger into sp

Posted by Jameschowdare under Sql Server on 12/7/2009 | Views : 1124 | Status : [Member] | Replies : 7
i think we did 't call trigger into sp




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
Where did you see that ?



Thank you for posting at Dotnetfunda
[Administrator]

Jameschowdare, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response