Understanding constraints and binding

Giganews Newsgroups
Subject: Understanding constraints and binding
Posted by:  Nacho (nacho.jor…@gmail.com)
Date: 7 Aug 2006

I'm implementing some database formatting and I need that values within
a column have certain limits ... let's say for example, they shouldn't
be <0 or >10000, but in the case I'm inserting values bigger then 10000
I would like that MSSQL "clip" this value to the upper limit (10000 in
this case) and the same with the lower limit (zero in this case).
Is that possible? or SQL just respond me with an error when the values
go beyond those limits and will abort the transaction?
Can someone put some light on this please???

Nacho

Replies