--不知道LZ是不是这个意思! Create Table Tb1 (S int) Insert tb1 select 8 Go Create Table Tb2 (I int) Insert tb2 select 5 ---------- Create Trigger Tri_tb2 On Tb2 For Insert As Declare @A int Select @A=I From Inserted If @A=2 Update Tb1 Set S=S+1 If @A=3 Update Tb1 Set S=S-1 ------------测试1 --向tb2中插入2时 Insert tb2 select 2 --tb1中S值增1 ------------测试2 Select * from tb1 --向tb2中插入3时 Insert tb2 select 3 --tb1中S值减1 Select * from tb1
两个表怎么连接?create trigger tr_b_update_insert on b for update,inserte as update a set s=s+case when i.i=2 then 1 when i.i=3 then -1 else 0 end from a,inserted i where a.连接字段=i.连接字段 and i.i in (2,3) go
Create trigger T_B on B for insert,update as begin if exists (select 1 from deleted) begin update A set S=S+1 from inserted INS where INS.I=2 end else begin update A set S=S-1 from inserted INS where INS.I=3 end end
Create Table Tb1 (S int)
Insert tb1 select 8
Go
Create Table Tb2 (I int)
Insert tb2 select 5
----------
Create Trigger Tri_tb2
On Tb2
For Insert
As
Declare @A int
Select @A=I From Inserted
If @A=2
Update Tb1
Set S=S+1
If @A=3
Update Tb1
Set S=S-1
------------测试1
--向tb2中插入2时
Insert tb2 select 2
--tb1中S值增1
------------测试2
Select * from tb1
--向tb2中插入3时
Insert tb2 select 3
--tb1中S值减1
Select * from tb1
on b
for update,inserte
as
update a
set s=s+case when i.i=2 then 1 when i.i=3 then -1 else 0 end
from a,inserted i
where a.连接字段=i.连接字段
and i.i in (2,3)
go
for insert,update
as
begin
if exists (select 1 from deleted)
begin
update A
set S=S+1
from inserted INS
where INS.I=2
end
else
begin
update A
set S=S-1
from inserted INS
where INS.I=3
end
end