USE master
GO

SET NOCOUNT ON
go

drop database test1
drop database test2
drop database test3
drop database test4
drop database test5
drop database test6
drop database test7
drop database test8
drop database test9
drop database test10
go

Create database test1
Create database test2
Create database test3
Create database test4
Create database test5
Create database test6
Create database test7
Create database test8
Create database test9
Create database test10
go

use test1
Create table test1.dbo.ta1 (col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))
go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"@x1<1001

begin

select @x2=@x1

insert into ta1

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test2

Create table test2.dbo.ta2

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta2

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test3

Create table test3.dbo.ta3

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta3

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test4

Create table test4.dbo.ta4

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta4

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test5

Create table test5.dbo.ta5

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta5

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test6

Create table test6.dbo.ta6

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta6

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test7

Create table test7.dbo.ta7

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta7

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test8

Create table test8.dbo.ta8

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta8

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test9

Create table test9.dbo.ta9

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta9

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end

go

use test10

Create table test10.dbo.ta10

(col1 int not null, col2 int, col3 char(30), col4 char(30), col5 char(4))

go

declare @x1 int, @x2 int, @ch3 char(30), @ch4 char(30), @ch5 char(4)

select @x1=1, @x2=1

select @ch3="test1. 1000 records. 123456789"

select @ch4="012345678901234567890123456789"

select @ch5="<br>"

while @x1<1001

begin

select @x2=@x1

insert into ta10

values (@x1, @x2, @ch3, @ch4, @ch5)

select @x1=@x1+1

end