用的SQL SERVER2012 VS版本是10 不能调试似乎
create trigger trigger_ProductGoods_update
on t_yms_Products
after update
as
declare @fid varchar(20), @fstandard numeric(19, 2);
select @fid = fid,@fstandard = fstandard from inserted;
if
((select min(t.fsupplierprice) from t_yms_SupplierProduct t
left join t_yms_stockComparison t1 on t1.FId = t.FstockComparisonID
where t1.FproductGoodsID = @fid and t.Fstatus=1 and
datediff(second,t.FLastUpdateTime,GETDATE())<(select FconfigValue from t_yms_systemconfig where FconfigName='供应商库存有效期')*3600)) <= @fstandard
begin
print'开始执行'
update t_yms_products set Fdiscount = 1 where fid = @fid
print' 执行更新'
end
我在更新后 查询如果是比fstand这个值小 就更新这个product表的 fdiscount字段 似乎没有作用 求教