-- 生成1到10连续整数
SELECT
number as Numb
FROM MASTER..spt_values
WHERE TYPE = 'P'
AND number >= 1
AND number <= 10;
sql server 生成连续整数
于 2023-11-27 11:08:03 首次发布
-- 生成1到10连续整数
SELECT
number as Numb
FROM MASTER..spt_values
WHERE TYPE = 'P'
AND number >= 1
AND number <= 10;