SQL字符串连接
当前有一数据表，表结构如下：
ID Name Type
1 A S
2 B S
3 C S
4 D M

现在想把Type＝“M”的数据的"Name"值连接成一个字符串，如：A;B;C

请问如何实现？

[解决办法]

with t as
(
   select (select Name+',' from table where Type='M' for xml path('')) as Name 
 
)
select LEFT(name,LEN(name)-1) from t

[解决办法]
declare @s varchar(8000)
select @s=isnull(@s,'')+rtrim(Name)+',' from 表名 where type='m'
select @s as result;