Hi All,
Im just just wondering which method is more efficent and the pros and cons of each of the following two:
Pass-through query
Select * from table1
Inner Join Openquery('links','Select * from table2') ls on table1.id = ls.id
And
Select * from table1
Inner Join Server.Database.dbo.table2 ls on table1.id = ls.id
Also, what is the name latter method?
Thanks for your advice!
Im just just wondering which method is more efficent and the pros and cons of each of the following two:
Pass-through query
Select * from table1
Inner Join Openquery('links','Select * from table2') ls on table1.id = ls.id
And
Select * from table1
Inner Join Server.Database.dbo.table2 ls on table1.id = ls.id
Also, what is the name latter method?
Thanks for your advice!