我的语法有什么问题？

发布于 2025-01-08 18:28:12 字数 513 浏览 0 评论 0原文

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

首先，我得到： 关键字“AS”附近的语法不正确。

因此，我将其删除并替换为具有完整表名称的别名，这给了我： 关键字“INNER”附近的语法不正确。

我发现了这个问题，这是我发现有关执行 INNER JOIN 的地方，但 SQL Server 无法正确解析它。有什么想法吗？

原文

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

For starters, I get:
Incorrect syntax near the keyword 'AS'.

So, I remove this and replace with the aliases with full table names, which gives me:
Incorrect syntax near the keyword 'INNER'.

I found this question which is where I found out about doing an INNER JOIN, but SQL Server isn't parsing this correctly. Any ideas?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

送你一个梦 2025-01-15 18:28:12

试试这个：

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 语句之后的表名/别名。

try this:

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

you missed the tablename/alias after the top statement.

回复收藏 0 原文

~没有更多了~