sql server cte 產生 1 - N 內的亂數.sql

;WITH CTE(N) AS (
	SELECT 1 N UNION ALL
	SELECT N + 1
	FROM CTE
	WHERE N < 9
)
SELECT *
FROM CTE
WHERE N = (SELECT FLOOR(RAND()*((SELECT MAX(N) FROM CTE)-1+1))+1)
OPTION (MAXRECURSION 0);