Chinaunix

标题: 求助：在游标中使用动态生成的SQL语句 [打印本页]

---

作者: catching    时间: 2003-07-11 09:33
提示: 作者被禁止或删除 内容自动屏蔽

---

作者: zhuzhichao    时间: 2003-07-11 10:05

1. 
   
2. declare @cSql varchar(1000)
   
3. set @cSql = \'declare cur cursor for \' + char(13)
   
4. set @cSql = @cSql + \' select * from b_person\'
   
5. exec(@cSql)
   
6. open cur
   
7. fetch cur into ......
   
8. while @@fetch_status = 0
   
9. begin
   
10.         ......
    
11.         fetch cur into ......
    
12. end
    
13. close cur
    
14. deallocate cur
    

复制代码

---

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)

Powered by Discuz! X3.2