详细介绍两种动态定义游标的方法

     declare @cursor_name varchar(36),@str nvarchar(4000)
select  @cursor_name=newid() 
DECLARE @ckbm varchar(20) 
exec('DECLARE ['+@cursor_name + '] CURSOR FOR select f_ckbm from tbda_ck')
exec('open ['+ @cursor_name+']')
set @str=N'fetch from ['+ @cursor_name +'] into @ckbm'
exec sp_executesql @str,N'@ckbm varchar(20) out',@ckbm out
while @@fetch_status = 0 
begin
    print @ckbm
    exec sp_executesql @str,N'@ckbm varchar(20) out',@ckbm out
end
exec('close ['+ @cursor_name+']')
exec('deallocate ['+ @cursor_name+']')

declare @sqlExec varchar(8000),@tableName varchar(255),@myvar varchar(20) 
　　set @tableName = 'Checkbag_info' 
　　set @sqlExec = 'declare cursor1 cursor for ' + CHAR(13) 
　　set @sqlExec = @sqlExec + ' select res_sort from ' + @tableName 
　　exec(@sqlExec) 
　　open cursor1 
　　fetch next from cursor1 into @myvar 
　　while @@fetch_status = 0 
　　begin 
　　print @myvar 
　　fetch next from cursor1 into @myvar 
　　end 
　　close cursor1 
　　deallocate cursor1