在我插入一条语句的时候,如何能把当前表里的内容清空一下啊!!
我用触发器实现,但是把我新插入的这条也清除了!
Create Trigger ct1
on mytable
for insert
as
delete from mytable
这条语句应该如何再做一下加工啊??
我用触发器实现,但是把我新插入的这条也清除了!
Create Trigger ct1
on mytable
for insert
as
delete from mytable
这条语句应该如何再做一下加工啊??
instead of insert
as
delete from inserted
instead of insert
as
select * from inserted
这样也行,用报错信息限止不能插入数据
create trigger ta_1 on mytable
for insert
as
if exists(select 1 from inserted)
begin
raiserror('不能插入!',16,1)
rollback tran
return
end
for insert
as
delete from mytable
insert into mytable select * from inserted
end
if exists(select * from mytable)
begin
delete from mytable
end
else
begin
insert into mytable values(.....)
end