--清除所有记录
truncate table stu
declare @i int
declare @begin datetime
declare @End datetime
set @i=1
set @begin=getdate()
while @i<100000
begin
insert into stu values(@i,'abcd'+str(@i))
set @i=@i+1
end
set @End=getdate()
select datediff(ss,@begin,@End) as 执行的时间