INF: Creating & Filling a Table with Sample Data in SQL Server (61793)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft SQL Server 7.0
This article was previously published under Q61793 SUMMARY
If you need to have a table with a large amount of data for running a
test, you can use the following control flow language to create and
fill a table for this purpose. The table, "x", is defined with the
following command:
create table x (a char(30),b int)
Sample Code
declare @count int
select @count=0
while @count<1000
begin
select @count=@count+1
insert x values( convert(char(30),@count) , @count)
end
Modification Type: | Major | Last Reviewed: | 12/3/2003 |
---|
Keywords: | kbusage KB61793 |
---|
|