更新库存SQL算法版
存储过程实现(内有详细注释,不再另外说明了)
Create
Procedure
sp_ComputeStock
@StoreroomId INT = NULL , -- 库房编号 @EquipmentIds VARCHAR ( 1000 ), -- 设备编号,各设备编号间用逗号隔开,例如:1,2,3,4 @EquipmentMount VARCHAR ( 1000 ) -- 设备数量,各设备数量间用逗号隔开,例如:11,15,20,5 AS SET NOCOUNT ON SET CURSOR_CLOSE_ON_COMMIT OFF -- 设置手动关闭游标,使事务不会影响到游标的打开和关闭 DECLARE @tb_EquipmentIds TABLE ( [ Id ] INT IDENTITY ( 1 , 1 ),EquipmentId INT ) -- 表变量,设备编号表 DECLARE @tb_EquipmentMount TABLE ( [ Id ] INT IDENTITY ( 1 , 1 ),EquipmentMount INT ) -- 表变量,设备数量表 INSERT INTO @tb_EquipmentIds SELECT * FROM dbo.f_splitSTR( |