blocks|key|2498904|text|SELECT+id,+ROW_NUMBER()+OVER+(+ORDER+BY+id)+as+number
FROM+WaitList+
WHERE+email+=+@Email;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2498905|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT id, ROW_NUMBER() OVER ( ORDER BY id) as number
FROM WaitList 
WHERE email = @Email;
</code></pre>

blocks|key|1504109|text|您的代码看起来像Server。不能分配变量并返回具有相同查询的结果集：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1504110|SELECT+id,+ROW_NUMBER()+OVER+(ORDER+BY+id)+as+number
FROM+WaitList+
WHERE+email+=+@Email;|code-block|syntax|javascript|1504111|将值赋值给变量是没有意义的。如果您想要匹配行的总数，那么使用聚合函数：|1504112|select+@cnt+=+count(*)
from+waitlist
where+email+=+@email;|1504113|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Your code looks like SQL Server. You cannot assign a variable and return a result set with the same query:

<pre><code>SELECT id, ROW_NUMBER() OVER (ORDER BY id) as number
FROM WaitList 
WHERE email = @Email;
</code></pre>

Assigning the value to a variable doesn't really make sense. If you want, say, the total number of matching rows, then use aggregation functions:

<pre><code>select @cnt = count(*)
from waitlist
where email = @email;
</code></pre>

blocks|key|1504125|text|如果您想要具有匹配的电子邮件地址的行号，但该表实际上没有行号，那么您应该创建一个CTE来分配行号，然后从其中选择特定的行.就像这样：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1504126|WITH+NumberedRows+AS+(
++++SELECT+[id],+[email],+ROW_NUMBER()+OVER+(ORDER+BY+id)+as+[Number]+
++++FROM+WaitList+
)
SELECT+@RowNumber+=+Number
FROM+NumberedRows
WHERE+email+=+@Email|code-block|syntax|javascript|1504127|注意，如果在此之前有SELECT语句，则需要确保使用分号终止SELECT语句(或其他SQL语句)。或者，如果你愿意的话，你可以用一个分号作为前缀，比如“；WITH+.”|1504128|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you want the number of the row that has the matching email address, but the table doesn't actually HAVE row numbers, then you should create a CTE to assign row numbers, and then select the specific row from that... something like this:

<pre><code>WITH NumberedRows AS (
 SELECT [id], [email], ROW_NUMBER() OVER (ORDER BY id) as [Number] 
 FROM WaitList 
)
SELECT @RowNumber = Number
FROM NumberedRows
WHERE email = @Email
</code></pre>

Note that if there are SELECT statements prior to this, you'll need to make sure you terminate the SELECT statement (or other SQL Statements) with a semi-colon. OR, if you wish, you could just prefix the WITH with a semi-colon, like ";WITH..."

blocks|key|1504130|text|+select+a.id+,+a.number+
+from
+(SELECT+id,+ROW_NUMBER()+OVER+(ORDER+BY+id)+as+number
+FROM+WaitList+
+WHERE+email+=+@Email)+a|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1504131|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> select a.id , a.number 
 from
 (SELECT id, ROW_NUMBER() OVER (ORDER BY id) as number
 FROM WaitList 
 WHERE email = @Email) a
</code></pre>

I have a query like so:

<pre><code>SELECT id, @RowNumber = ROW_NUMBER() OVER (ORDER BY id) as 'number' 
FROM WaitList 
WHERE email = @Email
</code></pre>

However I am getting error:

<pre><code>Incorrect syntax near the keyword 'as'.
</code></pre>

What I am trying to do is assign the ROW_NUMBER() to a variable.

I really need to get the row number from the WaitList table.

Could I put the results in variable table and then get the row number by selecting 'number'?

SQL Incorrect syntax near as Assigning output to variable

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个类似这样的查询：SELECT id, @RowNumber = ROW_NUMBER() OVER (ORDER BY id) as 'number' FROM WaitList WHERE email = @Email然而，我遇到了错误：Incorrect syntax near the keyword 'a...

问SQL不正确的语法接近于将输出分配给变量
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL不正确的语法接近于将输出分配给变量EN