Sqlserver统计查询用时

select 1,CURRENT_TIMESTAMP 

create table #s(CREATETIME DATETIME)

declare @i int = 1

WHILE @i<=200000
BEGIN
	INSERT INTO #s
	select getdate()
	SET @i = @i+1
END
select 2,CURRENT_TIMESTAMP