sql中用逗号拼接字符串
时间:2022-03-14 03:37
MSSQL中可以用STUFF函数拼接成字符串。
如:
SELECT FieldSomeElse, ( SELECT STUFF(( SELECT ‘,‘ + LinkField FROM Detail WHERE Id = Main.Id FOR XML PATH(‘‘) ), 1, 1, ‘‘) ) AS LinkFieldString FROM Main
时间:2022-03-14 03:37
MSSQL中可以用STUFF函数拼接成字符串。
如:
SELECT FieldSomeElse, ( SELECT STUFF(( SELECT ‘,‘ + LinkField FROM Detail WHERE Id = Main.Id FOR XML PATH(‘‘) ), 1, 1, ‘‘) ) AS LinkFieldString FROM Main