SQL Server 循环 - 如何遍历一组记录 [英] SQL Server loop - how do I loop through a set of records

问题描述

如何遍历来自选择的一组记录?

how do I loop through a set of records from a select?

举个例子，我有一些记录，我希望循环遍历，并对每条记录做一些事情.这是我选择的原始版本:

So say for example I have a few records that I wish to loop through and do something with each record. Here's a primitive version of my select:

select top 1000 * from dbo.table
where StatusID = 7 

谢谢

推荐答案

像这样使用 T-SQL 和游标:

By using T-SQL and cursors like this :

DECLARE @MyCursor CURSOR;
DECLARE @MyField YourFieldDataType;
BEGIN
    SET @MyCursor = CURSOR FOR
    select top 1000 YourField from dbo.table
        where StatusID = 7      

    OPEN @MyCursor 
    FETCH NEXT FROM @MyCursor 
    INTO @MyField

    WHILE @@FETCH_STATUS = 0
    BEGIN
      /*
         YOUR ALGORITHM GOES HERE   
      */
      FETCH NEXT FROM @MyCursor 
      INTO @MyField 
    END; 

    CLOSE @MyCursor ;
    DEALLOCATE @MyCursor;
END;

这篇关于SQL Server 循环 - 如何遍历一组记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！