《SQL2022下字符串字段内的字符排序》由会员分享,可在线阅读,更多相关《SQL2022下字符串字段内的字符排序(4页珍藏版)》请在金锄头文库上搜索。
1、 SQL2022下字符串字段内的字符排序-测试数据DECLARE T TABLE(COL VARCHAR(10)INSERT T SELECT WEFSAINSERT T SELECT DFSAINSERT T SELECT DQWF-数据生成;WITH TAS(SELECT top 26 ROW_NUMBER() OVER (ORDER BY ID) AS nFROM SYS.SYSOBJECTS),T2AS(SELECT col,CHAR(64+N) AS M,NFROM T JOIN TON CHARINDEX(CHAR(64+N),COL) 0)SELECTCOL,replace(SE
2、LECT M as data() FROM T2 WHERE COL = T3.COL ORDER BY N FOR XML PATH(), ,) AS NEWCOLFROM T T3-结果/*COL NEWCOL- -WEFSA AEFSWDFSA ADFSDQWF DFQW(3 行受影响)*/-附录:;WITH Numbers AS(SELECT (20)ROW_NUMBER() OVER(ORDER BY object_id) AS IDFROM sys.objects),Liang AS(SELECTA.col,B.ID,SUBSTRING(A.col,B.ID,1) AS vFROM t AS AJOIN Numbers AS BON SUBSTRING(A.col,B.ID,1)SELECTcol,REPLACE(SELECTv AS data()FROM LiangWHERE col=A.colORDER BY vFOR XML PATH(), ,)FROM t AS A