sql-server-2008 - 创建游标以遍历记录的SQL Server 2008请求示例

Question

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center获取指导。




7年前关闭。





有没有创建游标以遍历一堆记录的经验？如果可以的话，您可以为我提供一个基本的例子。谢谢

最佳答案

declare cur cursor for 
select id from tbl 
open cur
declare @id int
fetch next from cur into @id
while (@@FETCH_STATUS = 0)
begin
    print(@id)
    fetch next from cur into @id
end
close cur
deallocate cur

-- just replace "tbl" with your table name and "id" with your field name
-- and do whatever you want in begin-end block (now it simply prints the id of each record)

关于sql-server-2008 - 创建游标以遍历记录的SQL Server 2008请求示例，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/11856518/

上一篇：google-chrome-devtools - 删除单个文件的 chrome 缓存

下一篇：visual-studio-2010 - 此代码段有什么问题？

相关文章：

sql - 锁升级 - 这里发生了什么？

sql-server-2008 - SQL Server:获取表中记录的位置(普通)

C# 数据集和 DbNull 值

sql - MS SQL 2008 - 如何将 xml 值转换为 ms sql 表中的行集合？

sql - 如何根据 SQL Server 2008 中的特定参数返回所需的手动值

SQL累积值

不为空时的Sql Case语句

c# - 首先将 READ_COMMITTED_SNAPSHOT 与 EF 代码结合使用 5

sql-server-2008 - 无法使用Electronic将数据表单插入到SQL Server

mysql - 在迁移到 SQL Server 2008 之前将 MySQL SQL 模式设置得更严格

Answer 1

declare cur cursor for 
select id from tbl 
open cur
declare @id int
fetch next from cur into @id
while (@@FETCH_STATUS = 0)
begin
    print(@id)
    fetch next from cur into @id
end
close cur
deallocate cur

-- just replace "tbl" with your table name and "id" with your field name
-- and do whatever you want in begin-end block (now it simply prints the id of each record)