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:MajorLast Reviewed:12/3/2003
Keywords:kbusage KB61793