[ DB ] [ SQL ] [ SQL Server ] MS SQL 建立暫存表格 temp table - 轉載
範例 SQL:
1 IF OBJECT_ID(N'tempdb.dbo.#tmp_checkStatusCount', N'U') IS NOT NULL 2 DROP TABLE #tmp_checkStatusCount 3 SELECT 4 CONVERT(varchar(100), s.UpdateTime, 112) as updateTime, 5 e.checkStatus, 6 count(*) as amount 7 into tempdb.dbo.#tmp_checkStatusCount 8 FROM Errorcode as e WITH(NOLOCK) 9 LEFT JOIN statusTable as s WITH(NOLOCK) 10 on e.checkStatus = s.checkStatus 11 where countryCode ='USA' 12 and CONVERT(varchar(100), s.UpdateTime, 112) = '20151119' 13 GROUP BY CONVERT(varchar(100), s.UpdateTime, 112), e.checkStatus 14 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.
