-
本版专家分：19结帖率 100% -
table1
field1 varchar(20),
field2 float,
field3 float,
field4 date()
现在要求在向table1添加数据的同时，根据field4 < 添加记录的field4 and field1 = 添加记录的field1,查询table1里面field2的值，再用添加记录的field2的值 - 查询出来的field2的值，将他更新所添加记录的field3的值
在线等~~~谢谢了
-
本版专家分：5533 -
inserted
-
本版专家分：2063 -
insert into table
select a.field1.a.field2,b.field2-a.field2,a.field4 from table a,inserted b where a.field4<b.field4
and a.field1=b.field1
-
本版专家分：3479
-
create trigger tr_tr1 on tablename
for insert
as
declare @field1 varchar(20),
@field2 float,
@field3 float,
@field4 datetime
set nocount on
select @fields1=fields1,@field4=field4 from inserted
if exists(select *from table1 where field1=@field1 and filed4<@field4)
begin
select @field2=field2 from table1 where field1=@field1 and filed4<@field4
update table1 set field3=field2-@field2 where field4=@field4
end
set nocount off
-
本版专家分：1857 -
create trigger 触发器名 on table1
for insert
as
update table1 set field3 = b.field2-a.field2 from table1 a join inserted b on a.field1 = b.field1 and a.field4 < b.field4
