MSSQL select, insert, update, delete openquery 사용방법

update openquery(linked1, 'select ssn from testlinked where ssn=2')
set ssn=ssn + 1

insert openquery(linked1, 'select ssn from testlinked where 1=0') values (1000)

delete openquery(linked1, 'select ssn from testlinked where ssn>100')

 

* linked1 : DB 링크명

'select ssn from testlinked where ssn=2' : 실제 해당 DBMS에서 사용하는 쿼리