有两个表orders表,和users表
orders表里就order_id,user_id,order_prict这些列
users表里就user_id,user_rmb
然后就想建个触发器,当orders表里删除一行时,
users表里就相应的user_rmb这列的值减去被删除这行的order_prict这个值
谁能帮帮忙啊,很急~~~
create trigger a1 on orders
AFTER delete
as
begin
DECLARE @user_id int,@order_price int
select @user_id=user_id,@order_price=order_price from orders
update users set user_rmb=user_rmb-@order_price where user_id=@user_id
end
这样为什么没用
create trigger trigger_nameon ordersafter deleteasupdate users set user_rmb=users_rmb-(select order_prict from deleted) where users_id in (select users_id from deleted)