动态sql创建游标(sql server数据库)
http://blog.sina.com.cn/s/blog_561ef93d010001yt.html
/*********************************************/--动态sql生成游标的示例 sql server数据库/*********************************************/Declare @mysql nvarchar(100) Declare @mysql2 nvarchar(100) declare @index bigintSET @mysql = 'select Indx from bss_order' set @mysql2 = ' declare cur_test cursor for ' + @mysqlexec(@mysql2)open cur_testfetch next from cur_test into @indexclose cur_testdeallocate cur_testselect @index