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 ())