declare @des_xml nvarchar(max)set @des_xml ='<?xml verson="1.0" encoding="utf-8"?><province>'declare @id bigintdeclare @provinceid bigintdeclare @name nvarchar(50)declare cur cursorfor select * from T_Provincesopen curfetch next from cur into @id,@namewhile @@FETCH_STATUS=0begin set @des_xml = @des_xml + '<row id="' + cast(@id as nvarchar(10))+ '" provincename="' + @name + '"/>' fetch next from cur into @id,@nameend
set @des_xml = @des_xml + '</province>'close curdeallocate curprint @des_xml
积累点滴，沉淀知识。
转载于:https://www.cnblogs.com/leeke/archive/2013/04/10/3011498.html
