在SQL Server中查找最小的未使用的数字

WITH CTE AS (
    SELECT MIN(your_column) AS min_value
    FROM your_table
    UNION ALL
    SELECT min_value + 1
    FROM CTE
    WHERE min_value + 1 <= (SELECT MAX(your_column) FROM your_table)
)
SELECT TOP 1 min_value
FROM CTE
WHERE NOT EXISTS (SELECT 1 FROM your_table WHERE your_column = min_value)
ORDER BY min_value ASC;