What is the quickest way to fill a SQL table with dummy data? I have a wide table with about 40 fields of different kinds (int, bit, varchar, etc.) and need to do some performance testing. I'm using SQL Server 2008. Thank you! ...
Possible Duplicate: Quickest way to fill SQL Table with Dummy Data I'm looking for a tool that will generate insert statement for an existing database filled with dummy data. This is meant to allow testing of the system. I'm thinking about something that reads the type of each field and generates data accordingly. If the fiel...
Hi, I'd really like know if it's possible to do a select statement, which returns exactly same records, that we put into in clause? Sample: select * from table where table_id in (1, 2, 3, 666); This table for an example has only id-s from 1 to 100, so this select will return only three rows. What I need to do, to get also one (proba...