34,593
社区成员
发帖
与我相关
我的任务
分享
select * from openrowset('SQLOLEDB' , 'XFJ' ; 'Administrators' ; '' , AdventureWorks.Person.Address)
SELECT * FROM
OPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.26;User ID=sa;Password=123456').AdventureWorks.Person.Address
SELECT a.*
FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',
'SELECT GroupName, Name, DepartmentID
FROM AdventureWorks2008R2.HumanResources.Department
ORDER BY GroupName, Name') AS a;
select ID,Title from OpenRowset
('SQLOLEDB','192.168.1.26';'Administrators';'','select * from xfj.AdventureWorks.Person.Address')
SELECT a.* FROM OPENROWSET('SQLOLEDB','Server=192.168.1.26;Trusted_Connection=yes','SELECT * from AdventureWorks.Person.Address') a
SELECT a.*
FROM OPENROWSET(
'SQLOLEDB',
'Server=XFJ;Trusted_Connection=yes',
'SELECT * from AdventureWorks.Person.Address'
) a