-
IF UPDATE() function and text fields
I'm using IF UPDATE() function in the update trigger.
the problem is -- that bloody function evaluates to true all the bloody time for a text field, even if text field is not present in the update clause.
(I'm using SQL Server 6.5 with SP5a)
microsoft article about "IF UPDATE() functionality is broken in service pack 5, 5a" applies only to insert triggers....
any ideas? suggestions? am I crazy?
thanks in advance.
Gregory
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
|
|