mssql 类似于mysql group_concat 的函数
select top 10 wid, stuff(
(select ','+convert(varchar(25), rwid) from CombineBuying as t2 where t2.wid = t1.wid FOR XML PATH('')), 1, 1, ''
) as rwids from CombineBuying as t1 where t1.wid = '10033...
原创
2013-01-09 18:44:54 ·
836 阅读 ·
0 评论