融合两个字符串

最新推荐文章于 2020-11-09 19:25:52 发布

吉普赛的歌

最新推荐文章于 2020-11-09 19:25:52 发布

阅读量432

点赞数

分类专栏： # 练习

本文链接：https://blog.csdn.net/yenange/article/details/78559886

版权

练习专栏收录该内容

49 篇文章 1 订阅

订阅专栏

原贴：点击打开链接

DECLARE @s1 VARCHAR(20),@s2 VARCHAR(20)
SET @s1='123X56X89'
SET @s2='12XX56789'

;WITH tt1 AS (
	SELECT sv.number AS id,SUBSTRING(t1.c,sv.number,1) AS c 
	FROM (SELECT @s1 AS c)AS t1 CROSS APPLY [master].dbo.spt_values AS sv 
	WHERE sv.[type]='P' AND sv.number BETWEEN 1 AND LEN(t1.c)
), tt2 AS (
	SELECT sv.number AS id,SUBSTRING(t2.c,sv.number,1) AS c 
	FROM (SELECT @s2 AS c)AS t2 CROSS APPLY [master].dbo.spt_values AS sv 
	WHERE sv.[type]='P' AND sv.number BETWEEN 1 AND LEN(t2.c)
)
SELECT (
	SELECT  
	CASE WHEN a.c=b.c THEN a.c
		 WHEN a.c='X' THEN b.c
		 ELSE a.c END 
	FROM tt1 AS a INNER JOIN tt2 AS b ON a.id=b.id
	FOR XML PATH('')
) AS result
/*
result
123X56789
*/