|
2> CREATE TABLE xyz
3> (
4> col1 int PRIMARY KEY IDENTITY(1, 1) NOT NULL,
5> col2 int NOT NULL DEFAULT 999,
6> col3 char(10) NOT NULL DEFAULT 'ABCEFGHIJK'
7> )
8> GO
1>
2> SET NOCOUNT ON
3> DECLARE @counter int
4> SET @counter=1
5> WHILE (@counter <= 1000)
6> BEGIN
7> INSERT xyz DEFAULT VALUES
8> SET @counter=@counter+1
9> END
10> GO
1>
2>
3> drop table xyz;
4> GO
|