这里有3种方法来执行INSERT INTO #temp。方法1要求两个表具有完全相同的列名和计数。另外2种方法要求您定义要插入的列，因为我们不再使用SELECT *。

CREATE TABLE emails (
  email_address nvarchar(50)
);
  
CREATE TABLE locations (
  email_address nvarchar(50)
);
 
INSERT INTO emails VALUES ('test@test.com');
INSERT INTO locations VALUES ('test2@test2.com');

--Method 1
SELECT * INTO #temp FROM emails
UNION ALL
SELECT * FROM locations

SELECT *
FROM #temp;

--Method 2
SELECT *
INTO #temp2
FROM (
  SELECT
    email_address
  FROM emails
  UNION ALL
  SELECT
    email_address
  FROM locations
) as tbl

SELECT *
FROM #temp2;

--Method 3
WITH prelim AS (
  SELECT
      email_address
    FROM emails
    UNION ALL
    SELECT
        email_address
    FROM locations
)
SELECT *
INTO #temp3
FROM prelim;

SELECT *
FROM #temp3;

方法1结果：
| 电子邮件地址|
| - -|
| test@test.com |
| test2@test2.com |
方法2结果：
| 电子邮件地址|
| - -|
| test@test.com |
| test2@test2.com |
方法3结果：
| 电子邮件地址|
| - -|
| test@test.com |
| test2@test2.com |
fiddle