--创建链接服务器 exec sp_addlinkedserver 'ITSV' , '' , 'SQLOLEDB' , '远程服务器名或ip地址' --查询 select * into #TableOld FROM openquery(ITSV , 'exec(@sql)')
USE [test] GO /****** 对象: Table [dbo].[pvt] 脚本日期: 07/04/2011 11:24:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[pvt]( [VendorID] [int] NULL, [Emp1] [int] NULL, [Emp2] [int] NULL, [Emp3] [int] NULL, [Emp4] [int] NULL, [Emp5] [int] NULL ) ON [PRIMARY]insert into pvt values(1,4,3,5,4,4); insert into pvt values(2,4,1,5,5,5); insert into pvt values(3,4,3,5,4,4); insert into pvt values(4,4,2,5,5,4); insert into pvt values(5,5,1,5,5,5);
insert into #temp exec(@sql)
insert into #temp exec(@Sql) select * from #temp执行的时候 对象名 '#temp' 无效。
exec sp_addlinkedserver 'ITSV' , '' , 'SQLOLEDB' , '远程服务器名或ip地址'
--查询
select * into #TableOld
FROM openquery(ITSV , 'exec(@sql)')
GO
/****** 对象: Table [dbo].[pvt] 脚本日期: 07/04/2011 11:24:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[pvt](
[VendorID] [int] NULL,
[Emp1] [int] NULL,
[Emp2] [int] NULL,
[Emp3] [int] NULL,
[Emp4] [int] NULL,
[Emp5] [int] NULL
) ON [PRIMARY]insert into pvt values(1,4,3,5,4,4);
insert into pvt values(2,4,1,5,5,5);
insert into pvt values(3,4,3,5,4,4);
insert into pvt values(4,4,2,5,5,4);
insert into pvt values(5,5,1,5,5,5);
select * from #temp执行的时候 对象名 '#temp' 无效。