SQL loop

[meckeard]

Hi Gang,

I need to do some quick and dirty inserts into a table.
What's the best way to do it in SQL w/o manually inserting each record?

Is there a loop statement that would work? Or do I need to use a cursor?

Thanks,
Mark

 

[SonOfEmidec1100]

Whats the source of the rows you are inserting ? If you are selecting from another table you should be able to use something along the lines

INSERT INTO MyTable
SELECT field1,field2
FROM MyTable2

 

[balor]

If you don't have a source and just want to insert some test data you can use WHILE to create a loop.

Example:

DECLARE
@nNrOfRows int,
@nRow int

SET @nNrOfRows = 100
SET @nRow = 0

WHILE(@nNrOfRows > @nRow)
BEGIN
INSERT INTO ...
SET @nRow = @nRow + 1
END