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