方法一：
不知道多输出参数如何写：
| 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 exec('close [' @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 |
文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
