触发器取值问题。
cairg 2005-02-22 01:55:33 CREATE TRIGGER Tr_CpphdUpdateuser ON dbo.cp_warephd
FOR Insert,Delete,update AS /////////////系统先做insert操作再作delete操作
declare @i_zfbj varchar(2)
declare @d_zfbj varchar(2)
If Exists(Select * From Deleted)
begin
select top 1 @d_zfbj=isnull(d.zfbj,'8') from deleted d
--Raiserror (@d_zfbj,16,1)
end
If Exists(Select * From Inserted I)
Begin
select @i_zfbj=isnull(i.zfbj ,'8') from inserted i
-- Raiserror (@i_zfbj,16,1)/////做insert操作时取出值是2
end
If Exists(Select * From Deleted)
作delete操作@i_zfbj变成了空值,有没有什么好方法把值保存起来
Begin
/*更新可使用仓库库存量*/
-- Raiserror (@i_zfbj,16,1)
Update Cp_WareCkkc
Set usequantity= (Cp_WareCkkc.usequantity + (Select D.Quantity))
From Deleted D
Where Cp_WareCkkc.WareHouse= D.WareHouse And Cp_WareCkkc.systemcode = D.systemcode
and (@d_zfbj='2' ) and @i_zfbj='2'//////////@i_zfbj=''所以我无法正确执行,我希望是@i_zfbj=2
end