範例 SQL:
IF OBJECT_ID(N'tempdb.dbo.#tmp_checkStatusCount', N'U') IS NOT NULL
DROP TABLE #tmp_checkStatusCount
SELECT
CONVERT(varchar(100), s.UpdateTime, 112) as updateTime,
e.checkStatus,
count(*) as amount
into tempdb.dbo.#tmp_checkStatusCount
FROM Errorcode as e WITH(NOLOCK)
LEFT JOIN statusTable as s WITH(NOLOCK)
on e.checkStatus = s.checkStatus
where countryCode ='USA'
and CONVERT(varchar(100), s.UpdateTime, 112) = ''
GROUP BY CONVERT(varchar(100), s.UpdateTime, 112), e.checkStatus
ORDER BY CONVERT(varchar(100), s.UpdateTime, 112), e.checkStatus asc
重點:
create table 在 tempdb 中
#table 僅此連線可以使用
##table 其他連線可查詢此TABLE
原文連結
1.
http://deanma.blogspot.tw/2012/01/ms-sql-temp-table.html
2.