SELECT TOP 300
*
INTO #log
FROM Log WITH(NOLOCK)
WHERE
CreateDT >= '2017-08-17 09:00:03.507'
AND CreateDT <= '2017-08-17 19:03:03.733'
SELECT *
FROM #log
WHERE ErrorMsg LIKE '%错误%'
ORDER BY CreateDT DESC;
drop table #log
*
INTO #log
FROM Log WITH(NOLOCK)
WHERE
CreateDT >= '2017-08-17 09:00:03.507'
AND CreateDT <= '2017-08-17 19:03:03.733'
SELECT *
FROM #log
WHERE ErrorMsg LIKE '%错误%'
ORDER BY CreateDT DESC;
drop table #log