【SQL】用SQL傳回1-100

修改自暗黑執行緒大大的CODE //查詢SELECT DISTINCT NUMBER FROM master.dbo.spt_values WHERE name IS NULL可傳回一段0到2047的數字//

SELECT  CONVERT(VARCHAR(4), Num)+'m' as title, CONVERT(VARCHAR(4), Num) as value

FROM 

(

    SELECT DISTINCT NUMBER AS Num

    FROM master.dbo.spt_values

    WHERE name IS NULL

) NumberPool

WHERE Num BETWEEN 1 AND 100

ORDER BY Num 

執行結果