问题已解决 DECLARE @a DATETIME DECLARE @b INT SET @a=GETDATE() SELECT job,oper_num,bflush_type,wc,qty_released,complete FROM jobroute_erp A WHERE NOT EXISTS ( SELECT 1 FROM JOBROUTE WHERE JOB = A.JOB AND OPER_NUM = A.OPER_NUM ) SELECT @b=DATEDIFF(ms,@a,GETDATE()) PRINT @b现在在2005下耗时:90 ms
DECLARE @a DATETIME
DECLARE @b INT
SET @a=GETDATE()
SELECT job,oper_num,bflush_type,wc,qty_released,complete
FROM jobroute_erp A
WHERE NOT EXISTS ( SELECT 1 FROM JOBROUTE WHERE JOB = A.JOB AND OPER_NUM = A.OPER_NUM )
SELECT @b=DATEDIFF(ms,@a,GETDATE())
PRINT @b现在在2005下耗时:90 ms