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 |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2001-11-02 : 16:10:19
|
| I need to create a rule like this. here is the recorditemid | parentid | valueparent id refers to another itemidvalue cannot be greater than the value of its parent. not sure if a trigger is necessary or if there is another wayEssentially i want to rollback the insert or update and raise an error if the value is greater than its parentall i really need to know after doing some more research is how to reference the current record that the trigger is firing on.Thanks,Christian-=:SpasmatiK:=-Edited by - Cyclonik on 11/02/2001 16:21:02Edited by - Cyclonik on 11/02/2001 16:28:05 |
|
|
|
|
|
trigger?