Row Count Option

This command defines number of rows to be generated. It has a five forms.

Syntax form #1:
Rowcount Records="<Number of records to be generated>"
Example:
Rowcount Records="25000"

Syntax form #2:
Rowcount Random="<Number from:Number to>"
Example:
Rowcount Random="10:100"

Syntax form #3:
Rowcount Table="<Table Name>" Column="<Column Name>"
Example:
Rowcount Table="Order" Column="OrderID"

Syntax form #4:
Rowcount Sql="<SQL statement>"
Example:
Rowcount sql="select count(*) from Order where OrderDate>'12.01.2000'"

Syntax form #5:
Rowcount Driven="<Table Name>" Column="<Column Name>" Random="<Number from:Number to>"
Example:
Rowcount Driven="Order" Column="OrderID" Random="10:100"