如何将Sql Int值拆分为多行

DECLARE @start_value INT = 1;
DECLARE @end_value INT = 10;

WITH
    Numbers AS (
        SELECT @start_value AS num
        UNION ALL
        SELECT num + 1
        FROM Numbers
        WHERE num < @end_value
    )
SELECT * FROM Numbers;

DECLARE @start_value INT = 1;
DECLARE @end_value INT = 10;

WHILE @start_value <= @end_value
BEGIN
    SELECT @start_value AS num;
    SET @start_value = @start_value + 1;
END;

DECLARE @start_value INT = 1;
DECLARE @end_value INT = 10;

SELECT num
FROM (
    SELECT @start_value + ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1 AS num
    FROM sys.objects
) AS Numbers
WHERE num <= @end_value;