IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='TRI_物料與供應(yīng)商' AND TYPE='TR')
DROP TRIGGER TRI_物料與供應(yīng)商
GO
CREATE TRIGGER [TRI_物料與供應(yīng)商] ON [dbo].[物料與供應(yīng)商對(duì)照表] 
FOR INSERT, UPDATE, DELETE 
AS
DECLARE @稅率編碼 VARCHAR(10),@稅率 NUMERIC(18,6) 
SELECT @稅率編碼=稅率編碼,@稅率=稅率 FROM 稅率主文件
UPDATE 物料與供應(yīng)商對(duì)照表 SET 
含稅單位價(jià)格1=無(wú)稅單位價(jià)格1*(1+@稅率),含稅單位價(jià)格2=無(wú)稅單位價(jià)格2*(1+@稅率),
含稅單位價(jià)格3=無(wú)稅單位價(jià)格3*(1+@稅率),
含稅單位價(jià)格4=無(wú)稅單位價(jià)格4*(1+@稅率),含稅單位價(jià)格5=無(wú)稅單位價(jià)格5*(1+@稅率) 
WHERE 稅率編碼=@稅率編碼