CREATE TRIGGER GasSet_UPDATE
ON [GasSet]
for UPDATE
AS
begin
declare @gasid int
declare @gascode nvarchar(50)
declare @gasname nvarchar(50)
declare @gasunit nvarchar(50)
declare @gasstate int
select @gasid=GasID, @gascode=GasCode,@gasname=GasName, @gasunit=@gasunit, @gasstate=GasState from GasSet
insert into GasDC (GasID,GasCode,GasName,GasUnit,GasState) values (@gasid,@gascode,@gasname,@gasunit,@gasstate)
end
GO
当GasSet表发生更新,进行触发,将GasSet表中的所有记录,必须按照按1到n编号写入到GasDC中,若GasDc有记录先全部删除。
急,在线等!