User SqlServer Linked Server

Oracle Example:

     select * from openrowset('MSDAORA','E4MT';'mis';'mis','select * from mis.factory') as a

SqlServer Example:

    select * from openrowset('MSDASQL','DRIVER={SQL Server};SERVER=inllhdb01;UID=modkpi;PWD=modkpi','select * from modkpi.dbo.dept') as a