alter table dbo.tablename with nocheck add constraint chenk1 check (colname > 0), constraint pk_tablename primary key nonclustered(colname) GO
你的是>0 and unique 我的要求是<=0 or unique
create function dbo.funtest(@colname int) returns int as declare @i int if @colname >0 select @i = count(*) from tb where colname=@colname else set @i=1 return @i alter table dbo.tablename add constraint chenkname check (dbo.funtest(colname)=1)
constraint chenk1 check (colname > 0),
constraint pk_tablename primary key nonclustered(colname)
GO
我的要求是<=0 or unique
returns int
as
declare @i int
if @colname >0
select @i = count(*) from tb where colname=@colname
else
set @i=1
return @i
alter table dbo.tablename add
constraint chenkname check (dbo.funtest(colname)=1)