触发器的问题，在线等~~~~急呀

[monkeys]

table1
field1 varchar(20),
field2 float,
field3 float,
field4 date()

现在要求在向table1添加数据的同时，根据field4 < 添加记录的field4 and field1 = 添加记录的field1,查询table1里面field2的值，再用添加记录的field2的值 - 查询出来的field2的值，将他更新所添加记录的field3的值

在线等~~~谢谢了

[comszsoft]

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

[cloudchen]

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

[yelook]

inserted

[monkeys]

能否详细点呀~~~很急

[lh1979]

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