create trigger TR_T_Storage_Update on T_Storage after update as begin declare @b int,@c int,@id int select @b=b,@id=id from deleted select @c=b from inserted if update (State) begin insert into T_Sam (ID,Ccode,PeopleName,PeopleID,StoreName,Colleatime,,......) select ID,PeopleID,Barcode,StoreCode,StoreName,colleatime,state from deleted --历史数据; select ID,PeopleID,Barcode,StoreCode,StoreName,colleatime,state from inserted --新数据; end
on T_Storage
after update
as
begin
declare @b int,@c int,@id int
select @b=b,@id=id from deleted
select @c=b from inserted
if update (State)
begin
insert into T_Sam (ID,Ccode,PeopleName,PeopleID,StoreName,Colleatime,,......)
select ID,PeopleID,Barcode,StoreCode,StoreName,colleatime,state from deleted --历史数据;
select ID,PeopleID,Barcode,StoreCode,StoreName,colleatime,state from inserted --新数据;
end
end
因为我暂时没有环境做测试,或者楼主测试了麻烦告知一下结果。