
/*
   Nonlinked servers queries

   Prabu 6/6/05
*/  


select e.ssn
from OPENROWSET('SQLOLEDB', 'localhost'; 'cgs4366'; 'hello',
 company.dbo.employee) as e


select e.ssn
from OPENROWSET('SQLOLEDB', 'teachsql.aul.fiu.edu'; 'cgs4366'; 'microsoft',
 cgs4366.dbo.employee) as e



select ssn
from OPENDATASOURCE('SQLOLEDB', 'Data Source=localhost;
 User ID=cgs4366; password=hello').company.dbo.employee


select c.ssn
from OPENDATASOURCE('SQLOLEDB', 'Data Source=localhost;
 User ID=cgs4366; password=hello').cgs4366.dbo.employee as c


