Results 1 to 2 of 2

Thread: Triggers in SQL

  1. 08-18-2005, 10:11 AM #1
    AnnetteBean
    AnnetteBean is offline Registered User
    Join Date
    May 2003
    Posts
    30

    Unhappy Triggers in SQL

    I have a trigger in a sql script that runs an update, however there is one time when I run an update statement that I don't want the trigger to run. Is there any way that in that instant I can code the update script to not fire the trigger?

    Hope someone can help.

    Thanks
    Reply With Quote Reply With Quote
  2. 08-18-2005, 11:20 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can disable trigger temporarily ALTER TABLE t DISABLE TRIGGER tr;
    or
    You have to check for that condition in trigger code and exit out without doing anything.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules