有关数据库insert触发器游标语句,求大牛帮助看有错误没
CREATE TRIGGER T_check_weight
on TrItem
for INSERT
AS
BEGIN
DECLARE @shopkeeperNum VARCHAR(50);
DECLARE @bcode VARCHAR(30);
DECLARE @restWeight NUMERIC(10);
DECLARE cur_insert CURSOR FOR
SELECT c.num shopkeeperNum,bcode,SUM(qty) from inserted a,TrTotal b, tc_shopkeeper c WHERE a.SaleNo = b.SaleNo and b.EmployeeID = c.id GROUP BY c.num, bcode;
OPEN cur_insert;
fetch next from cur_insert into @shopkeeperNum,@bcode,@restWeight --读取下一行
WHILE @@fetch_status = 0
begin
UPDATE tc_restweight set restWeight = restWeight - @restWeight
WHERE bcode = @bcode and shopkeeperNum = @shopkeeperNum
fetch next from cur_insert into @shopkeeperNum,@bcode,@restWeight --读取下一行
end
CLOSE cur_insert
DEALLOCATE cur_insert
END