论坛 › SQL Server › SQL Server存储过程实现数据迴圈stored procedure foreach row table

资讯王 发表于 2011-7-28 22:29:37

SQL Server存储过程实现数据迴圈stored procedure foreach row table

SQL Server存储过程实现数据迴圈 stored procedure foreach row returned by querydeclare @field1 int
declare @field2 int
declare cur CURSOR LOCAL for
    select field1, field2 from sometable where someotherfield is null

open cur

fetch next from cur into @field1, @field2

while @@FETCH_STATUS = 0 BEGIN

    --execute your sproc on each row
    exec uspYourSproc @field1, @field2

    fetch next from cur into @field1, @field2
END

close cur
deallocate cur

查看完整版本: SQL Server存储过程实现数据迴圈stored procedure foreach row table