blocks|key|1451227|text|如果我们知道游标代码是什么样子，回答这个问题可能会更容易。也许您可以放入一个if语句，该语句检查条件，并仅在条件不存在时执行某些操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1451228|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

It might be easier to answer this if we knew what the cursor code looked like. Perhaps you can put in an if statement that checks for the condition and only does something if the condition is not present.

blocks|key|1177207|text|如果你用fetch在循环的底部编写代码(在循环之前使用初始的fetch+)，继续会跳到顶部，并再次处理相同的行。你可以使用GOTO跳转到底部的fetch部分，或者重新构造循环以在顶部获取，cointinue就可以工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1177208|你可以修改你的循环来使用GOTO...|1177209|...
...
if+<condition>
BEGIN
++++GOTO+Fetch_Next
END
....
....
Fetch_Next:
FETCH+NEXT+FROM+...|code-block|syntax|javascript|1177210|以下是一些示例代码，仅用于循环顶部的一次fetch，continue将起作用：|1177211|DECLARE+<cursor_name>+CURSOR+FOR
++++SELECT
++++FROM
++++WHERE
++++FOR+READ+ONLY

--populate+and+allocate+resources+to+the+cursor
OPEN+<cursor_name>

--process+each+row
WHILE+1=1
BEGIN

++++FETCH+NEXT+FROM+<cursor_name>
++++++++INTO+@a,+@b,+@c

++++--finished+fetching+all+rows?
++++IF+@@FETCH_STATUS+<>+0
++++BEGIN+--YES,+all+done+fetching
++++++++--exit+the+loop
++++++++BREAK
++++END+--IF+finished+fetching

++++--do+something+here--
++++--do+something+here--

++++IF+<your+condition>
++++BEGIN
++++++++CONTINUE++--+fetch+next+row
++++END

++++--do+something+here--
++++--do+something+here--

END+--WHILE

--close+and+free+the+cursor's+resources
CLOSE+<cursor_name>
DEALLOCATE+<cursor_name>|1177212|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

if you code your loop with the fetch at the bottom (with the initial fetch before the loop) continue will just jump you to the top, and process the same row again. you could use a GOTO to jump to the fetch part at the bottom or restructure the loop to fetch at the top and the cointinue will work.

you could modify your loop to use GOTO...

<pre><code>...
...
if &lt;condition&gt;
BEGIN
 GOTO Fetch_Next
END
....
....
Fetch_Next:
FETCH NEXT FROM ...
</code></pre>

Here is some sample code for only one fetch at top of loop, continue will work:

<pre><code>DECLARE &lt;cursor_name&gt; CURSOR FOR
 SELECT
 FROM
 WHERE
 FOR READ ONLY

--populate and allocate resources to the cursor
OPEN &lt;cursor_name&gt;

--process each row
WHILE 1=1
BEGIN

 FETCH NEXT FROM &lt;cursor_name&gt;
 INTO @a, @b, @c

 --finished fetching all rows?
 IF @@FETCH_STATUS &lt;&gt; 0
 BEGIN --YES, all done fetching
 --exit the loop
 BREAK
 END --IF finished fetching

 --do something here--
 --do something here--

 IF &lt;your condition&gt;
 BEGIN
 CONTINUE -- fetch next row
 END

 --do something here--
 --do something here--

END --WHILE

--close and free the cursor's resources
CLOSE &lt;cursor_name&gt;
DEALLOCATE &lt;cursor_name&gt;
</code></pre>

blocks|key|150948|text|为什么不直接使用if语句：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150949|IF+'condition+exists+that+I+want+to+update'
BEGIN

....

END

Fetch+Next|code-block|syntax|javascript|150950|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Why don't you just use an if statement:

<pre><code>IF 'condition exists that I want to update'
BEGIN

....

END

Fetch Next
</code></pre>

blocks|key|150959|text|简单的答案是插入一个IF块:+begin+loop+/+IF+row+is+good+BEGIN+...结束/结束循环。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|150960|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

The cheap answer is to insert an IF block: begin loop / IF row is good BEGIN ... END / end loop.

blocks|key|1453199|text|我从来没有发现过一个SQL游标，我不能稍微考虑一下就将其删除，而且性能收益通常是巨大的。您不能只选择要操作的行，而是逐行处理，这是不是有什么原因？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1453200|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I've never found a SQL cursor I couldn't remove with a little thought, and the performance gains are usually huge. Is there a reason you can't select only the rows you want to operate on, rather than doing row by row processing?

I have a SQL Server cursor. I want to skip one iteration of the loop when a specific condition occurs. Break takes you out of the cursor loop and continue does not appear to be doing anything. 

Is there a command that says "hey this record is no good so let go ahead and skip it and work on the next one".

By the way I know cursors are evil like drivers who go 43 MPH in the passing lane, but as often happens in software I'm stuck with it. 

Thanks

SQL Server How Do You Iterate Though a Cursor Loop Once When a Specific Condition Occurs

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我有一个SQL Server游标。当特定条件出现时，我想跳过循环的一次迭代。Break会将您带出光标循环，而continue似乎不会执行任何操作。是否有一个命令说“嘿，这个记录不好，所以让我们跳过它，继续下一个”。顺便说一句，我知道光标是邪恶的，就像在过路车道上以每小时43英里的速度行驶的司机一样，但就像在软件中经常发...

问SQL Server如何在发生特定条件时遍历游标循环一次
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL Server如何在发生特定条件时遍历游标循环一次EN