create trigger insert_del on st
for DELETE,INSERT
as
if exists(select 0 from deleted) and not exists(select 0 from inserted)
begin
delete from st_ss where serial=(select serial from deleted)
end
else if not exists(select 0 from deleted) and exists(select 0 from inserted)
begin
insert into st_ss(parent,order,type,name,no) select parent,order,type,name,no from inserted
end
drop trigger insert_del 不知道有什么问题,检查语法可以通过,但是点击确定就出现错误提示
“错误21001:[SQL-DMO]存储过程定义必须包含(标准StordProcedure的)名称和文本或(扩展StoredProcedure)库名”
for DELETE,INSERT
as
if exists(select 0 from deleted) and not exists(select 0 from inserted)
begin
delete from st_ss where serial=(select serial from deleted)
end
else if not exists(select 0 from deleted) and exists(select 0 from inserted)
begin
insert into st_ss(parent,order,type,name,no) select parent,order,type,name,no from inserted
end
drop trigger insert_del 不知道有什么问题,检查语法可以通过,但是点击确定就出现错误提示
“错误21001:[SQL-DMO]存储过程定义必须包含(标准StordProcedure的)名称和文本或(扩展StoredProcedure)库名”
create trigger insert_del on st
for DELETE,INSERT
as
begin
if exists(select 0 from deleted) and not exists(select 0 from inserted)
begin
delete from st_ss where serial=(select serial from deleted)
end
else if not exists(select 0 from deleted) and exists(select 0 from inserted)
begin
insert into st_ss(parent,order,type,name,no) select parent,order,type,name,no from inserted
end
end
go
drop trigger insert_del
go
create trigger insert_del on st
for DELETE,INSERT
as
if exists(select 0 from deleted) and not exists(select 0 from inserted)
begin
delete from st_ss where serial in (select serial from deleted)
end
else if not exists(select 0 from deleted) and exists(select 0 from inserted)
begin
insert into st_ss(parent,[order],type,name,no)
select parent,[order],type,name,no from inserted
end 试下吧
table下有【触发器】文件夹。选中【触发器】,单击右键,选“新建触发器”
for DELETE,INSERT
as
if exists(select 0 from deleted) and not exists(select 0 from inserted)
begin
delete from st_ss where serial in (select serial from deleted)
end
else if not exists(select 0 from deleted) and exists(select 0 from inserted)
begin
insert into st_ss(parent,[order],type,name,no)
select parent,[order],type,name,no from inserted
end
for DELETE,INSERT
as
if exists(select 0 from deleted) and not exists(select 0 from inserted)
begin
delete from st_ss where serial in (select serial from deleted)
end
else if not exists(select 0 from deleted) and exists(select 0 from inserted)
begin
insert into st_ss(parent,[order],type,name,no)
select parent,[order],type,name,no from inserted
end