|
|
|
|
|
TestBase 3.0 1 2 3 4 5 6 7 8 9 Upon clicking OK, your screen should be similar to the figure below. In the left pane, you have a listing of each column. In the right pane, it shows that 50 rows of data are going to be added. (50 is the maximum for the demo version, but the full product can generate as many as you want.)
Right clicking on the tbt_products table allows you to define which columns to include. For this example, I am simply including all columns. You can individually specify how many rows of data you want to be generated as well as if you want it to remove all of the data before generating test data. The create temporary data table allows you to dump the data to a temporary file that can be used in subsequent operations. This is primarily for multiple foreign keys referencing multiple tables. The temporary data file is not stored in the database and is cleaned up after execution completes.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
