Be carefull with check constraints on columns that can be null

Post date: Dec 2, 2009 4:52:21 PM

declare @t table ( MyValue int check(MyValue > 0))insert @t values (null)select * from @t

(1 row(s) affected)

(1 row(s) affected)