Created 16k rows with SQLServer

--Insert 16k rows with SQLServer
begin tran;
create table test1 (id integer, create_date datetime);

insert into test1(id, create_date) values(1, getdate());
insert into test1(id, create_date) select id+1     as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+2     as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+4     as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+8     as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+16    as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+32    as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+64    as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+128   as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+256   as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+512   as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+1024  as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+2048  as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+4096  as id, getdate() create_date from test1;
insert into test1(id, create_date) select id+8192  as id, getdate() create_date from test1;

commit tran;