create trigger trg_test on GuanLiXingWeiKouFenQingKuang
for insert,update,delete
as
begin
update GuanLiXingWeiJianChaBiao a
set
KaoHDF = a.KaoHDF-b.KouFZ
from
inserted b
where
a.[BiaoN]=b.[BiaoN] and a.[KaoHNRH]=b.[KaoHNRH] and a.[KouFBZH]=b.[KouFBZH]
update GuanLiXingWeiJianChaBiao a
set
KaoHDF = a.KaoHDF+b.KouFZ
from
deleted b
where
a.[BiaoN]=b.[BiaoN] and a.[KaoHNRH]=b.[KaoHNRH] and a.[KouFBZH]=b.[KouFBZH]
end
go
for insert,update,delete
as
begin
update GuanLiXingWeiJianChaBiao a
set
KaoHDF = a.KaoHDF-b.KouFZ
from
inserted b
where
a.[BiaoN]=b.[BiaoN] and a.[KaoHNRH]=b.[KaoHNRH] and a.[KouFBZH]=b.[KouFBZH]
update GuanLiXingWeiJianChaBiao a
set
KaoHDF = a.KaoHDF+b.KouFZ
from
deleted b
where
a.[BiaoN]=b.[BiaoN] and a.[KaoHNRH]=b.[KaoHNRH] and a.[KouFBZH]=b.[KouFBZH]
end
go
可是打不到要求
我也不是很懂你写的意思,第二个表里的一条数据对应第一个表里的多条数据,也就是说 总分值-(多条数据的扣分值之和)=考核得分第一个表里的多条数据的条数也不是一个固定值
算了
结贴了......