Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jackstow
Posting Yak Master
160 Posts |
 Posted - 2002-05-03 : 05:35:50
|
| I want to create a constraint on a table column so that the integer value in the column can only be updated by a preset amount (-1, +4, +14, +21) and other values will be rejected. Any ideas on the best way? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-05-03 : 06:15:19
|
| You can get the original value of the updated column in the trigger procedure, then you can do a comparison on them.Check out BOL for details....Tim |
 |
|
|
|
|
|
Constraint or trigger to check changes