A SQL server bug?
要在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,好像没有看到相关的内容。
posted on 2004-06-10 01:06:00 by zee 评论(6) 阅读(2078)