将数据表的某一列值，转换为逗号分隔字符串：
先准备一些数据：
DECLARE @t AS TABLE([Datas] NVARCHAR(40))INSERT INTO @t ([Datas]) VALUES(N'DF'),(N'W4F'),(N'EYY'),(N'ER'),(N'GFF'),(N'A445')SELECT [Datas] FROM @t ORDER BY [Datas]
一二句SQL代码的事：
DECLARE @CommaDelimitedString NVARCHAR(MAX)SELECT @CommaDelimitedString = ISNULL(@CommaDelimitedString + ',', '') + [Datas] FROM @t ORDER BY [Datas]SELECT @CommaDelimitedString
原文链接：http://www.cnblogs.com/insus/p/10852906.html
本站QQ群：前端 618073944 | Java 606181507 | Python 626812652 | C/C++ 612253063 | 微信 634508462 | 苹果 692586424 | C#/.net 182808419 | PHP 305140648 | 运维 608723728
经验首页