declare @d1 datetime set @d1=getdate()
select top 100 *
from [sd_qyxx]
where
qydm not in (select top 49900 [qydm] from [sd_qyxx] order by [qydm] asc)
order by [qydm] asc
select [语句执行花费时间(毫秒)]=datediff(ms,@d1,getdate())
select top 100 *
from [sd_qyxx]
where
qydm not in (select top 49900 [qydm] from [sd_qyxx] order by [qydm] asc)
order by [qydm] asc
select [语句执行花费时间(毫秒)]=datediff(ms,@d1,getdate())