Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you set off a trigger based on one column changing?
Message
From
01/06/2010 21:37:44
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01466971
Message ID:
01466992
Views:
80
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>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform