符号分割的字符串转换为XML,符号分割字符串xml
把某一符串分割的字符串转换为 XML格式:
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
可以把它写成一个自定义函数:
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
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。