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

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

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

ContractedBlock.gif ExpandedBlockStart.gif

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

Source Code

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

28036-20190526223709199-686694866.png

ContractedBlock.gif ExpandedBlockStart.gif

  1. SET ANSI_NULLS ON
  2. GO
  3. SET QUOTED_IDENTIFIER ON
  4. GO
  6. -- =============================================
  7. -- Author:      Insus.NET
  8. -- Create date: 2019-05-26
  9. -- Update date: 2019-05-26
  10. -- Description: 转换为XML
  11. CREATE FUNCTION [dbo].[svf_ConvertToXML] ( 
  12.      @comma_delimited_string NVARCHAR(MAX)
  13. )
  14. RETURNS XML
  15. AS
  16. BEGIN     
  17.     RETURN CAST(N'<insus>' + REPLACE(@comma_delimited_string, N',',N'</insus><insus>')  + N'</insus>' AS XML)
  18. END

Source Code

28036-20190526223853853-362265074.png

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

发表评论

表情：
评论列表 （有 0 条评论，378人围观）

还没有评论，来说两句吧...

相关阅读