xp_cmdshell 执行可执行文件
做链接服务器不好?
SELECT * INTO NEWTABLE FROM
OPENDATASOURCE(
'SQLOLEDB',
'Data Source=127.0.0.1; --修改
User ID=sa;Password=password' --修改
).Northwind.dbo.Categories
做链接服务器不好?
SELECT * INTO NEWTABLE FROM
OPENDATASOURCE(
'SQLOLEDB',
'Data Source=127.0.0.1; --修改
User ID=sa;Password=password' --修改
).Northwind.dbo.Categories
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','密码'
...
select * into newtable from srv_lnk.dbname.dbo.tablename