SQL使用技巧

（一） 合并行

SELECT STUFF('abcdef', 2, 3, 'ijklmn');

STUFF ( character_expression , start , length , replaceWith_expression )

 

SELECT * FROM test FOR XML PATH

https://www.cnblogs.com/xiaozhi1236/p/6344134.html?utm_source=itdadao&utm_medium=referral