大马资讯论坛 - 马来西亚中文资讯平台

标题: SQL Server存储过程实现数据迴圈stored procedure foreach row table [打印本页]

---

作者: 资讯王    时间: 2011-7-28 22:29
标题: 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

复制代码

---

欢迎光临 大马资讯论坛 - 马来西亚中文资讯平台 (http://freeinfo.com.my/)

Powered by Discuz! X3.3