Monday, February 20, 2012

Linked Server

What is the syntax for querying through a linked server without usiing openquery?
ie.
LinkedServer.Database.owner.table ??Yes, exactly that.|||What is the syntax for querying through a linked server without usiing openquery?
ie.
LinkedServer.Database.owner.table ??

Yes,

SELECT CustomerID
,CompanyName
FROM LinkedServer.Northwind.dbo.Customers

No comments:

Post a Comment