????--???????/??????????(openrowset)
????--1??openrowset
????--??????
????select * from openrowset( 'SQLOLEDB'?? 'sql???????? '; '????? '; '????'?????????.dbo.????)
????--????????
????select * into ?? from openrowset( 'SQLOLEDB '?? 'sql???????? '; '????? '; '???? '?????????.dbo.????)
????--?????????????
????insert openrowset( 'SQLOLEDB '?? 'sql???????? '; '????? '; '???? '?????????.dbo.????)
????select *from ?????
????--???±????
????update b
????set b.??A=a.??A
????from openrowset( 'SQLOLEDB '?? 'sql???????? '; '????? '; '???? '?????????.dbo.????)as a inner join ????? b
????on a.column1=b.column1
????2.--openquery?÷???????????????
????--??????????????????????????
????exec sp_addlinkedserver 'ITSV '?? ' '?? 'SQLOLEDB '?? '????????????ip??? '
????--???
????select *
????FROM openquery(ITSV?? 'SELECT * FROM ?????.dbo.???? ')
????--?????????????
????insert openquery(ITSV?? 'SELECT * FROM ?????.dbo.???? ')
????select * from ?????
????--???±????
????update b
????set b.??B=a.??B
????FROM openquery(ITSV?? 'SELECT * FROM ?????.dbo.???? ') as a
????inner join ????? b on a.??A=b.??A