set statistics io on
declare @d datetime
set @d=getdate()
Delete [bbs8899].[dbo].t_article where NOT EXISTS(
select top 1000 f_id from [bbs8899].[dbo].t_article where f_sortnumber=3 and f_fid is null order by f_ftime desc
)
select [語句執(zhí)行花費(fèi)時(shí)間(毫秒)]=datediff(ms,@d,getdate())
|
