[SQL SERVER] Insertar N números en una tabla (ciclo)

DECLARE @first AS INT SET @first = 1 DECLARE @step AS INT SET @step = 1 DECLARE @last AS INT SET @last = 1000 BEGIN TRANSACTION WHILE(@first <= @last) BEGIN INSERT INTO Table_Name VALUES(@first) SET @first += @step END COMMIT TRANSACTION

Fuente