向临时表中插入数据 - Code

在创建临时表并像这样声明数据类型之后;

CREATE TABLE #TempTable(
ID int,
Date datetime,
Name char(20))

然后，我如何插入已经在数据库中的物理表上持有的相关数据?

当前回答

SELECT * 
INTO #TempTable
FROM table

2015-06-17 07:30:12

其他回答

SELECT  ID , Date , Name into #temp from [TableName]

2013-04-02 11:13:17

我在SQL Server中插入的方法。此外，我通常检查是否存在临时表。

IF OBJECT_ID('tempdb..#MyTable') IS NOT NULL DROP Table #MyTable

SELECT b.Val as 'bVals'
  INTO #MyTable
FROM OtherTable as b

2014-05-05 02:30:59

SELECT * 
INTO #TempTable
FROM table

2015-06-17 07:30:12

INSERT INTO #TempTable (ID, Date, Name) 
SELECT id, date, name 
FROM physical_table

2012-08-02 13:59:05

INSERT INTO #TempTable(ID, Date, Name)
SELECT OtherID, OtherDate, OtherName FROM PhysicalTable

2012-08-02 13:58:30

aliyun