在SQL Server中,这会将100条记录从Customers表插入到tmpFerdeen :-
SELECT top(100)*
INTO tmpFerdeen
FROM Customers
是否可以跨UNION ALL SELECT执行SELECT INTO :-
SELECT top(100)*
FROM Customers
UNION All
SELECT top(100)*
FROM CustomerEurope
UNION All
SELECT top(100)*
FROM CustomerAsia
UNION All
SELECT top(100)*
FROM CustomerAmericas
不太确定在哪里添加INTO子句。
发布于 2009-02-26 16:54:31
这在SQL Server中有效:
SELECT * INTO tmpFerdeen FROM (
SELECT top 100 *
FROM Customers
UNION All
SELECT top 100 *
FROM CustomerEurope
UNION All
SELECT top 100 *
FROM CustomerAsia
UNION All
SELECT top 100 *
FROM CustomerAmericas
) as tmp
发布于 2012-09-27 18:26:09
为此,您根本不需要派生表。
只需将INTO
放在第一个SELECT
之后
SELECT top(100)*
INTO tmpFerdeen
FROM Customers
UNION All
SELECT top(100)*
FROM CustomerEurope
UNION All
SELECT top(100)*
FROM CustomerAsia
UNION All
SELECT top(100)*
FROM CustomerAmericas
发布于 2012-09-27 12:05:11
SELECT * INTO tmpFerdeen FROM
(SELECT top(100)*
FROM Customers
UNION All
SELECT top(100)*
FROM CustomerEurope
UNION All
SELECT top(100)*
FROM CustomerAsia
UNION All
SELECT top(100)*
FROM CustomerAmericas) AS Blablabal
这个"Blablabal“是必要的
https://stackoverflow.com/questions/591382
复制相似问题