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

DECLARE @Payment XML
SET @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)),'')<>''
BEGIN

INSERT 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 T2

END