符号分割的字符串转换为XML

清疚 2021-11-22 09:12 322阅读 0赞

把某一符串分割的字符串转换为 XML格式：  
[![28036-20190526222149966-976280207.png][]][28036-20190526222149966-976280207.png]

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

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

Source Code

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

[![28036-20190526223709199-686694866.png][]][28036-20190526223709199-686694866.png]

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][]

SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    
    -- =============================================
    -- Author:      Insus.NET
    -- Create date: 2019-05-26
    -- Update date: 2019-05-26
    -- Description: 转换为XML
    CREATE FUNCTION [dbo].[svf_ConvertToXML] ( 
         @comma_delimited_string NVARCHAR(MAX)
    )
    RETURNS XML
    AS
    BEGIN     
        RETURN CAST(N'<insus>' + REPLACE(@comma_delimited_string, N',',N'</insus><insus>')  + N'</insus>' AS XML)
    END

Source Code

[![28036-20190526223853853-362265074.png][]][28036-20190526223853853-362265074.png]

转载于:https://www.cnblogs.com/insus/p/10928041.html

[28036-20190526222149966-976280207.png]: /images/20211122/a91ff918c1f849c392d8c65a531a81f5.png
[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211122/674c7c1ec9934f3e88a76e568b22cba4.png
[28036-20190526223709199-686694866.png]: /images/20211122/17e725688a2b4a6881f727db19492746.png
[28036-20190526223853853-362265074.png]: /images/20211122/a41affa5cb3a420cb00b9980f359f016.png