把某一符串分割的字符串转换为 XML格式：

 

DECLARE @str NVARCHAR(MAX) = N'fd,re,45,tyu,976,qwer,gdsg,uyt'DECLARE @xml XML = CAST(N'
      
       ' + REPLACE(@str, N',',N'
      
      
       ')  + N'
      ' AS XML)SELECT @xml

 

可以把它写成一个自定义函数：

SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:      Insus.NET-- Create date: 2019-05-26-- Update date: 2019-05-26-- Description: 转换为XMLCREATE FUNCTION [dbo].[svf_ConvertToXML] (      @comma_delimited_string NVARCHAR(MAX))RETURNS XMLASBEGIN         RETURN CAST(N'
      
       ' + REPLACE(@comma_delimited_string, N',',N'
      
      
       ')  + N'
      ' AS XML)END