摘要:要在SQL Server里Create 一个类似这样的View： SELECT A.item, A.descrip AS name, d.Description AS subcatalog,       c.GroupName AS [catalog]FROM items A(NOLOCK) INNER JOIN      SERVER2.info.dbo.GroupCatalog b ON A.ItemCatalog = b.[Catalog] INNER JOIN      SERVER2.info.dbo.Groups c ON b.GroupID = c.GroupID INNER JOIN      SERVER2.info.dbo.ItemCatalog d ON b.[Catalog] = d.[Catalog] 写好SQL以后，在Enterprise Manager里New 一个View，然后把SQL Paste 上去，Query Designer 会重新组织SQL变成这样: SELECT A.item, A.descrip AS name, d.Description AS subcatalog,       c.GroupName AS [catalog]FROM items WITH (NOLOCK) A INNER JOIN      SERVER2.info.dbo.GroupCatalog b ON A.ItemCatalog = b.[Catalog] INNER JOIN      SERVER2.info.dbo.Groups c ON b.GroupID = c.GroupID INNER JOIN      SERVER2.info.dbo.ItemCatalog d ON b.[Catalog] = d.[Catalog]     但是很不幸的是这个SQL是不正确的，虽然Query Designer 的SQL 语法检查查不出来，但执行 Or 在QA里检查语法都会出错..   查了一下KB，好像没有看到相关的内容。...[阅读全文]