Join Query

[murugavelmsc]

hi,

in sql server,
i want to join two table in different server using join query.
guide me

thanks,
murugavel

[deepuv04]

Hi,

If you want to retrieve data from another server or remote server, you need to add it to linked servers. Then only you can retrieve the data from that server,

use the following code:

 
USE MASTER
GO
EXEC master.dbo.sp_addlinkedserver
   @server = 'SERVER_NAME',  --This is an ODBC connection that is setup on the machine.
   @srvproduct = '',
   @provider = 'SQLNCLI',
   @datasrc = 'SERVER_NAME',
   @catalog = 'DATABASE_NAME'
go
EXEC master.dbo.sp_addlinkedsrvlogin
    @rmtsrvname=N'SERVER_NAME',
    @useself=N'False',
    @locallogin=NULL,
    @rmtuser=N'USER_NAME',
    @rmtpassword='PASSWORD'
 
go
 
 
    SELECT * 
    FROM OpenQuery([SERVER_NAME], 'select * from Table_Name') AS T1 INNER JOIN
         Table_Name AS T2 ON T1.Column_Name = T2.Column_Name 
 
 

Thanks