XML数据保存至表中（批量）

DECLARE @Payment XMLSET @Payment='<DataSet><Table><Type>1</Type><Way>T</Way><Content>2346</Content></Table><Table><Type>1</Type><Way>T</Way><Content>123123</Content></Table></DataSet>'--将XML格式的支付帐号字符串转换成Table并将数据插入客户支付方式表中 IF ISNULL(cast(@Payment as varchar(max)),'')<>''BEGININSERT INTO UserPayment(PayType,Account,PayConfig)SELECT T2.[Type].value('.','varchar(1)') AS [TYPE],T2.Way.value('.','varchar(1)') AS Way,T2.[CONTENT].value('.','varchar(max)') AS [CONTENT]FROM(SELECT T.Records.query('Type') AS [Type],T.Records.query('Way') AS Way,T.Records.query('Content') AS [CONTENT]FROM @Payment.nodes('DataSet/Table') AS T(Records)) AS T2END