Just Code‎ > ‎

Be carefull with check constraints on columns that can be null

posted Dec 2, 2009, 8:52 AM by Peter Henell
declare @t table 
(
    MyValue int check(MyValue > 0)
)

insert @t values (null)

select * from @t
(1 row(s) affected)
(1 row(s) affected)
Comments