34,576
社区成员
发帖
与我相关
我的任务
分享
IF OBJECT_ID ('TB_trigger', 'TR') IS NOT NULL
DROP TRIGGER TB_trigger
GO
CREATE TRIGGER TB_trigger
ON TB
AFTER INSERT
AS
if exists(select 1 from TB where exists(select 1 from inserted A where A.id = tb.id))
begin
RAISERROR ('ID重复,插入失败', 16, 10);
end
GO