alter table Activity_numblist add constraint uq_id unique(A_Numblist, BatchID)
Go
Go
---多字段相同值约束
INSERT INTO [EDBCDB].[dbo].[Activity_numblist]
([A_Numblist]
,[BatchID]
,[EmplID]
,[Status]
,[CreatTime])
VALUES
( '132434331','1231231','123','0','2015-2-3')
GO