Thursday, June 12, 2014

MSSQL - Communicating one database to another using opendatasource

Communicating one database to another using opendatasource.

Example;

select UserId , Username , EmployeeId

from OPENDATASOURCE('SQLOLEDB', 'Data Source=172.166.10.116; User ID=sa;Password=12345678').hrms.dbo.employee_list  
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)