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])