如果，你想在一台数据库服务器上，查询另一个台数据服务器的数据该如何做呢？如果，你想在同一台数据服务器上，在不同的数据库之间查询数据，又该怎么办呢？那就让我为你介绍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 ...

[LINKEDSERVER].TBRWeb.dbo.TeamMaster TM ON TS.TeamID = TM.TeamID WHERE Project = 1 ORDER BY StatsDate DESC, OverallRank ASC </pre><BR><BR>So, to answer your question, SQL Server seems to be smart ...