只要有权限直接select,insert 就可以了 一个select创建新表的例子 select * into database1..table1 from database2..table whereinsert的例子 insert into database1..table1 select * from database2..table2 where ...
select * into 目的库.dbo.新表名 from 源表
insert into databasename1.dbo.tablename1 select * from tablename
使用OpenRowSet insert into tablename1 SELECT a.* FROM OPENROWSET('SQLOLEDB','servername';'UserID';'Password', 'SELECT * FROM databasename1.dbo.tablename2') AS a GO
insert into servername.databasenane1..tablename1 select * from 原表
insert into servername1.database1..table1 select * from servername2.database2..table2 where ...
如果跨服务器,要先建立服务起联接(linkserver),然后在语句中使用 from linkservername.databasename..table 建立服务器联接可以在企业管理器中
一个select创建新表的例子
select * into database1..table1 from database2..table whereinsert的例子
insert into database1..table1
select * from database2..table2
where ...
select * from tablename
insert into tablename1
SELECT a.*
FROM OPENROWSET('SQLOLEDB','servername';'UserID';'Password',
'SELECT * FROM databasename1.dbo.tablename2') AS a
GO
select * from 原表
select * from servername2.database2..table2
where ...
from linkservername.databasename..table
建立服务器联接可以在企业管理器中