[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 

Trackbacks 0 / Comments 0

티스토리 툴바