Hello All,
Is there any provision to ignore the trigger when i update a row in a table.

Thanks,
Loges

DISABLE TRIGGER is probably what you are looking for.

Member Avatar for RudyM

Is the trigger only on table update (not insert)? What's the trigger intended for? If you need to ignore it only for certain cases, could you alter the trigger code to only execute the code when conditions are met? I ask all this because there must have been a reason for the trigger in the first place.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.