用于模拟订单容量的SQL Server循环(无限循环问题)

DECLARE @counter INT = 1;

WHILE @counter <= 10
BEGIN
    -- 执行循环操作
    PRINT '循环执行次数: ' + CAST(@counter AS VARCHAR(10));
    SET @counter = @counter + 1;
END

DECLARE @orderId INT;
DECLARE @orderName VARCHAR(100);

DECLARE orderCursor CURSOR FOR
SELECT OrderId, OrderName FROM Orders;

OPEN orderCursor;

FETCH NEXT FROM orderCursor INTO @orderId, @orderName;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 执行循环操作
    PRINT '订单ID: ' + CAST(@orderId AS VARCHAR(10)) + ', 订单名称: ' + @orderName;

    FETCH NEXT FROM orderCursor INTO @orderId, @orderName;
END

CLOSE orderCursor;
DEALLOCATE orderCursor;

WITH RecursiveFunction AS (
    SELECT 1 AS Counter

    UNION ALL

    SELECT Counter + 1
    FROM RecursiveFunction
    WHERE Counter < 10
)
SELECT Counter
FROM RecursiveFunction;