SELECT INTO 语句创建一个新表,并用 SELECT 的结果集填充该表。新表的结构由选择列表中表达式的特性定义,例如:SELECT Shippers.*, Link.Address, Link.City, Link.Region, Link.PostalCode INTO NewShippers FROM Shippers JOIN LinkServer.DB.dbo.Shippers AS Link ON (Shippers.ShipperID = Link.ShipperID)SELECT INTO 可将几个表或视图中的数据组合成一个表。
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('TEST')) BEGIN --表已经存在 INSERT INTO TEST SELECT * FROM ...... END ELSE BEGIN --表不存在 SELECT * INTO TEST FROM ... END
谢谢aw511(点点星灯),但是这个方法的前提是要建表。我要的是之前没有这个表。根据查询自动生成的。 --------------------------------------------------------------------------------- 楼主理解错了,select ... into ...语句在执行插入数据的同时创建表,该表必须未创建
Link.Region, Link.PostalCode
INTO NewShippers
FROM Shippers
JOIN LinkServer.DB.dbo.Shippers AS Link
ON (Shippers.ShipperID = Link.ShipperID)SELECT INTO 可将几个表或视图中的数据组合成一个表。
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('TEST'))
BEGIN
--表已经存在
INSERT INTO TEST SELECT * FROM ......
END
ELSE
BEGIN
--表不存在
SELECT * INTO TEST FROM ...
END
---------------------------------------------------------------------------------
楼主理解错了,select ... into ...语句在执行插入数据的同时创建表,该表必须未创建