THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Administration » Tips » Development » Design   (RSS)
  • Using linked servers, OPENROWSET and OPENQUERY

    SQL Server has a few mechanisms to reach out to another server (even another server type) and query data from within a Transact-SQL statement. Among them are a set of stored credentials and information (called a Linked Server), a statement that uses a linked server called called OPENQUERY, another called OPENROWSET, and one called OPENDATASOURCE. ...
    Posted to Buck Woody (Weblog) by BuckWoody on March 16, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement