create database doismilhoes
go
use doismilhoes
go

create table agenda(
nome_completo varchar(100),
endereco varchar(100))

create table joinagenda(
codjoinagenda int identity not null,
nome varchar(100)
)


declare @cont as int
set @cont = 1
while @cont <=2000000
begin
	insert into agenda values ('Pessoa '+convert(varchar(10),@cont),'Rua '+convert(varchar(10),@cont))
	insert into joinagenda values ('Pessoa '+convert(varchar(10),@cont))
	set @cont = @cont + 1
end