新建 文本文档.txt

简单邮电信息管理

CREATE TRIGGER insert_order ON [dbo].[Order_Info] 
FOR INSERT 
AS

declare @diff money
declare @c_money money
declare @o_name varchar
declare @c_name varchar

select @diff=inserted.Diff,@o_name=inserted.Cust_Name
from inserted


select  @c_money=Cust_Info.C_Money,@c_name=Cust_Info.Name
from Cust_Name where Cust_Info.Name=@o_name

update Cust_Info
set Cust_Info.c_money=@c_money+@diff