declare @i as int
declare @begintime as datetime
set @begintime = getdate()
set @i = 0
while @i < 100
begin
insert into TestT (title,info,flag) values ('title'+cast(@i as varchar),'info'+cast(ceiling(rand() * 100) as varchar ),ceiling(rand() * 2))
set @i = @i + 1
end
select datediff(ms,@begintime,getdate()) as '執行時間'
sql执行时间
最新推荐文章于 2024-07-24 17:08:13 发布