//服务器
create table upd(bb image)
insert upd(bb)
select * from openrowset(bulk 'c:\Updater.exe', single_blob) a
select DATALENGTH (bb) from upd
//方法1:客户数据库
create table upd(bb image)
insert upd(bb)
SELECT * FROM
OpenRowSet(
'SQLOLEDB',
'192.168.0.254'; --链接服务器
'gg'; --登录名称
'sa11!!', --登录密码
'SELECT * FROM master..upd' --查询数据
)
或
SELECT *
FROM OPENDATASOURCE(
'SQLOLEDB',
'Data Source=192.168.0.254;User ID=sa;Password='
).ProductRecord..upd
方法2:
//服务器
EXEC sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.0.26'
EXEC sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa',''
select * from srv_lnk.[ProductRecord].dbo.[upd]
insert srv_lnk.[ProductRecord].dbo.[upd] select * from master..upd
EXEC sp_dropserver 'srv_lnk','droplogins'
//客户服务器
create table ##tb(aa varchar(1000))
insert into ##tb
select ''+char(13)+char(10)+'0'+char(13)+char(10)+char(13)+char(10)+char(13)+char(10)+char(13)+char(10)+'y'+char(13)+char(10)+char(13)+char(10)
exec master..xp_cmdshell 'bcp ##tb out e:\3.txt -Ubx -Psa11!! /c'
exec master..xp_cmdshell 'bcp "select top 1 bb from ProductRecord..upd" queryout "e:\Updater.exe" -Ubx -Psa11!! -Ubx <e:\3.txt'
drop table ##tb
exec master..xp_cmdshell 'dir e:\'