摘要:要在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,好像没有看到相关的内容。...[
阅读全文]