sql-server-2008 - 我的语法有什么问题？

Question

WHILE @@ROWCOUNT <> 0
BEGIN
     CHECKPOINT;
    DELETE TOP (300000)
      FROM [dbo].[Event] AS E
     INNER JOIN #tempEvents AS TE
        ON E.[EventID] = TE.[EventID]
END

首先，我得到: Incorrect syntax near the keyword 'AS'.
因此，我将其删除并替换为具有完整表名的别名，这给了我: Incorrect syntax near the keyword 'INNER'.
我找到了这个 question这是我发现做 INNER JOIN 的地方，但 SQL Server 没有正确解析它。有任何想法吗？

Answer 1

尝试这个:

WHILE @@ROWCOUNT <> 0
BEGIN
     CHECKPOINT;
    DELETE TOP (300000) E
      FROM [dbo].[Event] AS E
     INNER JOIN #tempEvents AS TE
        ON E.[EventID] = TE.[EventID]
END

您错过了 top 语句后的表名/别名。