Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you set off a trigger based on one column changing?
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01466971
Message ID:
01466993
Views:
57
>I did it later.
>
>
>First, really should start doing some of it before , especially when you see certain names who have replied (can easily list off a half-dozen)
>
>Second, UPDATE() function is usually not a good solution - it returns a TRUE simply if the column was involved in an UPDATE statement, regardless of whether the column value actually changed.
>
>third....start thinking quality, not quantity <s>

I know what UPDATE() returns and its pitfalls.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform