sql server 生成连续整数

-- 生成1到10连续整数
SELECT number as Numb FROM MASTER..spt_values WHERE TYPE = 'P' AND number >= 1 AND number <= 10;