22,207
社区成员
发帖
与我相关
我的任务
分享
if exists(select name from sysobjects where name='l')
drop trigger l --检查数据库中是否存在此名字的触发器
create trigger l
on lkn
instead of insert
as
begin
if exists(select 1 from lkn a,inserted i where a.bookid=i.bookid)
begin
RAISERROR('已存在此书号,输入错误!!!',16,1)
rollback
end
else
begin
insert lkn select * from inserted
end
end
go
if exists(select name from sysobjects where name='l')
drop trigger l --检查数据库中是否存在此名字的触发器
create trigger l
on lkn
for insert
as
begin
if exists(select 1 from lkn a,inserted i where a.bookid=i.bookid)
begin
RAISERROR('已存在此书号,输入错误!!!',16,1)
rollback
end
end
go
if exists(select name from sysobjects where name='l')
drop trigger l --检查数据库中是否存在此名字的触发器
create trigger l
on lkn
for insert
as
begin
if exists(select 1 from lkn a,inserted i where a.bookid=i.bookid)
begin
RAISERROR('已存在此书号,输入错误!!!,16,1)
rollback
end
end
go