Can I call triggers in stored procedures or vice versa?

    Requires Free Membership to View

    Login

Triggers cannot be called directly. Instead they are fired automatically when you perform an insert/update or delete on a table that has triggers. Therefore, you cannot call a trigger in a stored procedure. You can perform an insert / update or delete that will force a trigger to fire. As to the second part of your question, you can absolutely execute stored procedures in the source code of a trigger.

This was first published in November 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top