create trigger 名 on B for insert as if exists(select * from inserted where state>=80) insert A(字段1,字段2) select no,name from inserted where state >= 80
create trigger 名 on B for update as if exists (select 1 from A,inserted where a.字段1=b.no) begin update A set 字段1=no,字段2=name from B where A.字段1=B.no end else begin insert A(字段1,字段2) select no,name from inserted where state >= 80 end
错了点: create trigger 名 on B for update as if exists (select 1 from A,inserted where a.字段1=b.no) begin update A set 字段1=no,字段2=name from inserted B where A.字段1=B.no where state>=80 end else begin insert A(字段1,字段2) select no,name from inserted where state >= 80 end
create trigger trigA on B for update as declare @s int set @s=status from inserted if @s>=80 begin insert into A (no,name) select no,name from inserted end
create trigger triname on B for update as declare @staus int declare @no char(10) declare @name char(10) select @no=no,@name=name from inserted where staus>=80 insert into A (no,name) values (@no,@name)
create trigger trigname on B for insert,update as select * into A from B where state>=80
for insert
as
if exists(select * from inserted where state>=80)
insert A(字段1,字段2)
select no,name from inserted where state >= 80
for update
as
if exists (select 1 from A,inserted where a.字段1=b.no)
begin
update A
set 字段1=no,字段2=name
from B where A.字段1=B.no
end
else
begin
insert A(字段1,字段2)
select no,name from inserted where state >= 80
end
create trigger 名 on B
for update
as
if exists (select 1 from A,inserted where a.字段1=b.no)
begin
update A
set 字段1=no,字段2=name
from inserted B where A.字段1=B.no where state>=80
end
else
begin
insert A(字段1,字段2)
select no,name from inserted where state >= 80
end
for update
as
declare @s int
set @s=status from inserted
if @s>=80
begin
insert into A (no,name) select no,name from inserted
end
for update
as
declare @staus int
declare @no char(10)
declare @name char(10)
select @no=no,@name=name from inserted where staus>=80
insert into A (no,name) values (@no,@name)
for insert,update
as
select * into A from B where state>=80