數(shù)據(jù)庫原理實踐報告參考格式-資料下載頁
2025-07-21 11:35本頁面
【正文】 存儲 FOR UPDATEAS IF 0ANY(SELECT 存儲量 FROM inserted) BEGIN DECLARE SC CURSOR FOR SELECT 倉庫號,材料號 FROM inserted WHERE 存儲量0 DECLARE @sid INT,@mid INT,@s INT OPEN SC FETCH NEXT FROM SC INTO @sid,@mid WHILE @@FETCH_STATUS=0 BEGIN SELECT @s=存儲量 FROM deleted WHERE 倉庫號=@sid AND 材料號=@mid UPDATE 存儲 SET 存儲量=@s WHERE 倉庫號=@sid AND 材料號=@mid PRINT STR(@sid,3)+39。號倉庫39。+STR(@mid,3)+39。號材料庫存不足!39。 FETCH NEXT FROM SC INTO @sid,@mid END CLOSE SC DEALLOCATE SC ENDGO測試腳本：USE 生產(chǎn)管理GOINSERT INTO 材料 VALUES(2,39。銅39。,5000)INSERT INTO 材料 VALUES(3,39。煤39。,1000)INSERT INTO 存儲 VALUES(2,1,1)INSERT INTO 存儲 VALUES(3,1,1)GOUPDATE 存儲 SET 存儲量=存儲量10GOSELECT * FROM 存儲GOl 實踐總結(jié)
研究報告相關(guān)推薦
鄂ICP備17016276號-1