如果，你想在一台数据库服务器上，查询另一个台数据服务器的数据该如何做呢？如果，你想在同一台数据服务器上，在不同的数据库之间查询数据，又该怎么办呢？那就让我为你介绍Synonym和openquery吧。 1, 什么是Synonym Synonym（同义词）是Sql 2005的新特性。

I've got an ASP.NET app w/ a SQL backend. The SQL backend has a linked server (Access db) that is has several views that call from the linked tables.<BR><BR>Everything works fine in QA and Enterprise ...

I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.<BR><BR>Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...