求助：在游标中使用动态生成的SQL语句

zhuzhichao

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
    

复制代码