比如 create TABLE Prog ( ID bigint IDENTITY(1,1) PRIMARY KEY CLUSTERED, ChnID int not null unique, )create trigger prog_t on prog instead of insert as if exists(select 1 from prog a Inner Join inserted b On a.chnid=b.chnid) begin raiserror('有重复值!',10,1) rollback tran end else insert prog select chnid from inserted
create TABLE Prog
(
ID bigint IDENTITY(1,1) PRIMARY KEY CLUSTERED,
ChnID int not null unique,
)create trigger prog_t
on prog
instead of insert
as
if exists(select 1 from prog a Inner Join inserted b On a.chnid=b.chnid)
begin
raiserror('有重复值!',10,1)
rollback tran
end
else
insert prog select chnid from inserted