数量不断增加的存储过程

Question

任何人都可以在mssql中提供教程或完整的脚本:

exec up_AddMyCashItemByItem 'usernum','0','1','1','1','0'

我想自动usernum直到最后一行计数!

so应该自动执行此操作。

 exec up_AddMyCashItemByItem '1','0','1','1','1','0'
 exec up_AddMyCashItemByItem '2','0','1','1','1','0'
 exec up_AddMyCashItemByItem '3','0','1','1','1','0'

到给定表的最后一行为止!

Answer 1

DECLARE @currentVal INT = 1, @maxVal INT = 4000;
WHILE @currentVal <= @maxVal
BEGIN
    EXEC up_AddMyCashItemByItem @currentVal,'0','1','1','1','0';
    SET @currentVal = @currentVal + 1;
END;