SET STATISTICS PROFILE ON;
SET STATISTICS IO ON;
SET STATISTICS TIME ON;
GO
/*--你的SQL脚本开始*/
SELECT l2.num,l1.*
FROM uvTaskList l1 ,
( SELECT WS_ID ,
ROW_NUMBER() OVER ( ORDER BY WS_ID DESC ) AS num
FROM uvTaskList
WHERE ALLOWED_OPERATOR_CAL LIKE '%118%'
) l2
WHERE l1.WS_ID = l2.WS_ID
AND l2.num BETWEEN 61 AND 70;
GO
/*--你的SQL脚本结束*/
SET STATISTICS PROFILE OFF;
SET STATISTICS IO OFF;
SET STATISTICS TIME OFF;
DECLARE @d DATETIME;
SET @d = GETDATE();
/*你的SQL脚本开始*/
SELECT l2.num,l1.*
FROM uvTaskList l1 ,
( SELECT WS_ID,ROW_NUMBER () OVER (ORDER BY WS_ID DESC) AS num FROM uvTaskList
--WHERE ALLOWED_OPERATOR_CAL LIKE '%118%'
) l2
WHERE l1.WS_ID = l2.WS_ID
AND l2.num BETWEEN 61 AND 70;
/*你的SQL脚本结束*/
SELECT [语句执行花费时间(毫秒)] = DATEDIFF(ms,@d,GETDATE());