본문 바로가기

프로그램 경험/Database

[SqlServer] OPENROWSET / OPENDATASOURCE


SELECT * FROM OPENROWSET('SQLOLEDB','192.168.10.12';'userid';'password','SELECT * FROM  dbo.Table_A WITH (NOLOCK)');



SELECT * FROM  OPENDATASOURCE('SQLOLEDB','SERVER=192.168.10.12;UID=userid;PWD=password').DBNAME.dbo.Table_A