update触发器为什么不执行?
CREATE TRIGGER updateprice ON [dbo].[j_user]
FOR UPDATE
AS
declare @pf int,@selpf int
set @pf=(select j_pf from j_user where j_int =(select j_int from inserted))
set @selpf=(select j_pf from inserted)
if @pf<>@selpf
begin
if @selpf<60
begin
update j_user set j_price=0 where j_int =(select j_int from inserted)
end
else
begin
if @selpf<80
begin
update j_user set j_price=j_price*0.8 where j_int =(select j_int from inserted)
end
end
end
---------------------不知为什么不执行这个触发器,就算直接在表上面作更新也没有反应