摘要:
测试sql语句执行时间,备档用的新建表:pagetest--添加数据declare @i intset @i=0while(@i<90000)begin insert into pagetest select cast(floor(rand()*10000) as int),left(newid(),10),getdate() set @i=@i+1end--测试速度declare @begin_date datetimedeclare @end_date datetimedeclare @tab table(id int)select @begin_date = getdate(... 阅读全文