当前位置: 动力学知识库 > 问答 > 编程问答 >

How to set minimum value for a SQL Server column

问题描述:

I am using SQL Server 2008 R2

I want to set a column minimum value

Column type is int

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 ..

分享给朋友:
您可能感兴趣的文章:
随机阅读: