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

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

1. declare @field1 int
   
2. declare @field2 int
   
3. declare cur CURSOR LOCAL for
   
4.     select field1, field2 from sometable where someotherfield is null
   
5. 
   
6. open cur
   
7. 
   
8. fetch next from cur into @field1, @field2
   
9. 
   
10. while @@FETCH_STATUS = 0 BEGIN
    
11. 
    
12.     --execute your sproc on each row
    
13.     exec uspYourSproc @field1, @field2
    
14. 
    
15.     fetch next from cur into @field1, @field2
    
16. END
    
17. 
    
18. close cur
    
19. deallocate cur

复制代码