SQL快速生成大量数据记录及日志记录

use master  
drop database dbname  
create database dbname  
go  
use dbname  
 
go  
 
create table testlog ( usr varchar(50),pwd varchar(100))  
 
go  
--先插入一条数据  
insert into testlog select 'asdfasdfsadfasf','asdfasdfasfdasdf' 
 
go  
--复制表到他本身,执行20次,生成1048576条数据  
declare @i int 
declare @d1 datetime  
set @i=0  
while @i<20  
begin 
set @d1 = getdate()  
insert into [testlog] select * from [testlog]   
set @i=@i+1  
print '第' + Cast(@i as varchar(50)) + '圈，用时：' + Cast(datediff(ms,@d1,getdate()) as varchar(50)) + 'ms' 
end 
 
 
--收缩日志  
use master  
dump transaction [dbname] with no_log  
backup log [dbname] with no_log  
dbcc shrinkdatabase([dbname])