Difference between openrowset,Linked server,Opendatasource [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, o开发者_运维技巧verly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

Difference between openrowset,Linked server,Opendatasource and openquery in sql server

---

You don't say what you're trying to do or how your confused but briefly: Linked servers allows you to connect to another instance of SQL Server running on a different machine. OPENROWSET is an alternative method to accessing tables in a linked server and is an ad hoc method of accessing remote data using OLE DB. OPENDATASOURCE allows you to connect with using a linked server name.

Take a look on MSDN or SQLServer Central, there are some good summaries and examples on there.