accountreceivablemaster_insert.sql

来自「用vb.net写的基于c/s结构的进销存程序设计源代码」· SQL 代码 · 共 25 行

CREATE TRIGGER AccountReceivableMaster_Insert
ON AccountReceivableMaster
FOR INSERT 
AS
/* 如果修改记录数是0就结束触发程序 */ 
IF @@ROWCOUNT = 0 RETURN
/* 定义变量 
@CustomerID : 客户编号
@Advance : 暂收款
*/
DECLARE @CustomerID Char(8)
DECLARE @Advance Decimal(12, 0)
/* 找出新增的客户编号, 暂收款 */
SELECT @CustomerID = CustomerID, @Advance = Advance
FROM inserted
/*计算暂收款*/
UPDATE Customer SET Advance = Advance + @Advance                       
WHERE CustomerID = @CustomerID