游标

declare @Result nvarchar(Max)
declare @AuthorityZone nvarchar(Max)=''
declare @Apply_Type nvarchar(50)=''
declare @ProductCode nvarchar(50)=''
set @Result='';
DECLARE My_Cursor CURSOR --定义游标
FOR (select AuthorityZone,Apply_Type,ProductCode from Agent_Authorization where PK_Agent='10' AND dr=0) --查出需要的集合放到游标中
OPEN My_Cursor; --打开游标
FETCH NEXT FROM My_Cursor Into @AuthorityZone,@Apply_Type,@ProductCode ; --读取第一行数据
WHILE @@FETCH_STATUS = 0
BEGIN
set @Result=@Result+'产品线:' +(select FieldName from Sale_Dictionary where FieldID=@ProductCode) +','+'应用类型:'+(select FieldName from Sale_Dictionary where FieldID=@Apply_Type)+','+'授权区域:'+@AuthorityZone+';';
FETCH NEXT FROM My_Cursor into @AuthorityZone,@Apply_Type,@ProductCode; --读取下一行数据
END
CLOSE My_Cursor; --关闭游标
DEALLOCATE My_Cursor; --释放游标