CREATE TRIGGER [chonfu] ON [dbo].[caiji]
FOR INSERT
AS
if not exists(select 1 from caiji where dz=(select dz from inserted))
begin
print '数据重复'
rollback tran
end
没反应一直添加
...全文
8544打赏收藏
sql 触发器 防止插入重复数据
CREATE TRIGGER [chonfu] ON [dbo].[caiji] FOR INSERT AS if not exists(select 1 from caiji where dz=(select dz from inserted)) begin print '数据重复' rollback tran end 没反应一直添加
create TRIGGER flx_isexist
ON book_style
for INSERT
AS
begin
declare @string varchar(50)
select @string=bookstyle from inserted
IF ((select count(*) from book_style where book_style.bookstyle = @string)>1)
begin
rollback tran
raiserror ('该类型以存在!',16,1)
return
end
end
go