12-temptable.sql

来自「SQL Server 2005基础教程一书的源代码.」· SQL 代码 · 共 9 行

CREATE TABLE #SharesTmp
(ShareDesc varchar(50),
Price numeric(18,5),
PriceDate datetime)
INSERT INTO #SharesTmp
SELECT s.ShareDesc,sp.Price,sp.PriceDate
  FROM ShareDetails.Shares s
  JOIN ShareDetails.SharePrices sp ON sp.ShareId = s.ShareId
SELECT * FROM #SharesTmp