openrowset應用

（1）

 

select *  from openrowset
('sqloledb','server=SqlSrv1;uid=test20081106;pwd=64007',AdventureWorks.HumanResources.vEmployee )

 

（2）

 

SELECT Employees.*
FROM OPENROWSET( 'SQLNCLI', 'Server=SqlSrv1;Trusted_Connection=yes',
'SELECT EmployeeID, FirstName, LastName, JobTitle
FROM AdventureWorks.HumanResources.vEmployee
ORDER BY LastName, FirstName'
) AS Employees