I am using SQL Server 2008 R2
I want to set a column minimum value
Column type is
I want to set minimum value of 0
So if I update the column with -32 it should automatically set column value to 0
The simplest solution is to force the calling code to correct their data rather than magically alter it on insert. To do that, add a check constraint:
Alter Table MyTable Add Constraint CK_MyTable_Col Check ( MyCol >= 0 )
Use Check Contraints ..