Create Trigger kb
on B for insert
as
begin
update b set iri=inserted.bi*a.rqi_a+a.rqi_b from inserted inner join a
on(a.road_name=inserted.road_name)
end
on B for insert
as
begin
update b set iri=inserted.bi*a.rqi_a+a.rqi_b from inserted inner join a
on(a.road_name=inserted.road_name)
end
Create Trigger kb
on B for insert
as
begin
declare @i decimal(18,3),@road_name varchar(20)
select @i=inserted.bi*a.rqi_a+a.rqi_b,@road_name=inserted.road_name from inserted inner join a
on(a.road_name=inserted.road_name) update b set iri=@i where road_name=@road_name
end
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER TRIGGER InsertRqi ON [dbo].[rqi]
FOR INSERT
as
beginupdate rqi set iri = design.rqi_a + design.rqi_b*inserted.bi
from inserted inner join design
on(rqi.road_name = design.road_name)update rqi set rqi = 11.5 - 0.75 * iri
update rqi set
rqi_score =
case
when rqi>=8.5 then '优'
when rqi>=7 and rqi<8.5 then '良'
when rqi>=5.5 and rqi<7 then '中'
when rqi>=4 and rqi<5.5 then '次'
when rqi<4 then '差'
end
endGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO服务器: 消息 107,级别 16,状态 3,过程 InsertRqi,行 8
列前缀 'rqi' 与查询中所用的表名或别名不匹配。
我只要改变添加进来的数据啊
update rqi set rqi.iri = design.rqi_a + design.rqi_b * inserted.bi
from inserted inner join design
on(inserted.road_name=design.road_name)