Dan G,
Thanks for the info. I couldn't find them either because I was looking for a separate function, I didn't realize it was just a clause of the create trigger command - the article at sql-server-performance.com was misleading.
>Dan,
>
>Yeah, these functions are well hidden ;-)
>
>Check CREATE TRIGGER.
>
>>>To help reduce the unnecessary running of code in an UPDATE trigger, you can take advantage one of two different functions: UPDATE() (available in SQL Server 2000) or COLUMNS_UPDATED() (available in SQL Server 7.0 and 2000).
>>
>>Well, ya learn something new every day. And the odd part is that I can't find either function in BOL.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only