Microsoft KB Archive/61793

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

Article ID: 61793

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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, &quot;x&quot;, 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 KB61793

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.