How can INSERT INTO a table 300 times within a loop in SQL?

Question

I would like to insert a value retrieved from a counter in SQL and repeat it 300 times.

Something like:

DECLARE @Counter = 0;  -- BEGIN Loop      SET @Counter = @Counter + 1      INSERT INTO tblFoo VALUES(@Counter) -- REPEAT 300 times 

How can I achieve this? Thanks

Answer 1

You may try it like this:

DECLARE @i int = 0 WHILE @i < 300  BEGIN     SET @i = @i + 1     /* your code*/ END 

Answer 2

DECLARE @first AS INT = 1 DECLARE @last AS INT = 300  WHILE(@first <= @last) BEGIN     INSERT INTO tblFoo VALUES(@first)     SET @first += 1 END