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 |
|
tech_1
Posting Yak Master
129 Posts |
 Posted - 2013-01-06 : 22:07:13
|
| I have a table:IDSettingNameSettingValue (tinyint)What I want, is to automatically increment SettingValue to the next logical bitwise value, if that makes sense? i.e: 1, 2, 4, 8, 16 etc...is this possible to do somehow even if it is using triggers of some kind on the insert?Thank you. |
|
|
tech_1
Posting Yak Master
129 Posts |
Posted - 2013-01-06 : 22:34:08
|
| ok so I got that done by creating a TRIGGER on insert.But now, what is a record in that table is updated?I want to see if they changed a certain columns' value and if so, to roll it back so it goes back to the original value before the update.thoughts? |
 |
|
|
|
|
|
Auto increase column on insert by x amount?