IF OBJECT_ID('dbo.Numbers') IS NOT NULL DROP TABLE dbo.Numbers;
CREATE TABLE dbo.Numbers (Number INT PRIMARY KEY);
WITH Tally (N) AS (
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) - 1
FROM sys.objects s1 CROSS JOIN sys.objects s2
)
INSERT INTO dbo.Numbers (Number)
SELECT N
FROM Tally
WHERE N <= 10000; -- Ajuste conforme necessário
select * from Numbers
Resultado:
