Possible to bypass a trigger when doing a query on a triggered table?
Posted on 2003-11-18
I have a trigger on a table. Users coming in from the web may modify the record, which automatically sets the LastModified date to the current date and time. This field is used on user searches. However, there are some fields in the record that only Administrators of the application can see. But when the administrators change the record, the LastModified date is also updated; but I don't want this to happen. So I was wondering if there is some command I can append to my update query that would cause the trigger on the table not to happen. Hopefully there is something. It would seem logical if there was. Like:
SET Blah = 'test'
or something like that. Thanks.