Adding Lots of Bogus Data to some tables

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  July 13, 2010 at 10:40 am

  #221211

  Hello Everyone

  I am in the middle of testing some Transaction Log backups. I would like to insert some bogus data, something like a half million rows, I really don't care what it is. Maybe just a number count from 1 - 500,000 would be fine.

  How can I add that many rows without that many insert statements? Something like filling a tally table.

  I would rather not have to use a Cursor. I even have trouble typing that word 😀

  Thanks

  Andrew SQLDBA

• Andy Gerard

  SSC Eights!

  Points: 832

  More actions

  July 13, 2010 at 11:08 am

  #1192237

  There are plenty of ways to loop in SQL without a cursor. A while loop with an insert statement and some incrementing values to get you unique records is probably your best bet.

  http://www.databasejournal.com/features/mssql/article.php/3100621/T-SQL-Programming-Part-2---Building-a-T-SQL-Loop.htm