INF: Creating & Filling a Table with Sample Data in SQL Server

ID: Q61793

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2

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

Additional query words: Transact-SQL


Keywords          : kbusage SSrvServer 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 9, 1999