SELECT * into tablename
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ip;User ID=sa;Password=hello'
).pubs.dbo.a
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=ip;User ID=sa;Password=hello'
).pubs.dbo.a
Master..cmdShell 'bcp 库名..表名 in 表名.Txt -c -t , -r \n -Sservername -Usa -Ppassword'
EXEC master..xp_cmdshell 'bcp test.dbo.P_Aspect in c:\temp1.txt -c -q -S"servername" -U"sa" -P""'
//导入 EXEC master..xp_cmdshell 'bcp test.dbo.P_Aspect out c:\temp1.txt -c -q -S"servername" -U"sa" -P""'
//导出
EXEC sp_addlinkedserver '别名','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
exec sp_addlinkedsrvlogin @rmtsrvname='别名',@useself='false',@locallogin='sa',@rmtuser='sa',@rmtpassword='密码'
GO
然后你就可以如下:
select * from 别名.库名.dbo.表名
insert 库名.dbo.表名 select * from 别名.库名.dbo.表名
select * into 库名.dbo.新表名 from 别名.库名.dbo.表名
go
BULK INSERT 库名.dbo.['表名'] FROM 'D:\表名.Txt'