try this,select Id,UserId as 用户名,UserName,Password as 密码,
RolseId,AdminAreaID,LastIp,Position,Education,
Contact,Home_address,Disabled as 是否启用,
case State WHEN 0 THEN '离线' when 1 then '在线' end as 当前状态,
(select stuff((select ','+RolesName
from Sys_Roles
where charindex(','+cast(ID as nvarchar)+',',
','+replace(a.RolseId,'''','')+',',
1)>0
for xml path('')),1,1,''))
FROM Sys_Users a
RolseId,AdminAreaID,LastIp,Position,Education,
Contact,Home_address,Disabled as 是否启用,
case State WHEN 0 THEN '离线' when 1 then '在线' end as 当前状态,
(select stuff((select ','+RolesName
from Sys_Roles
where charindex(','+cast(ID as nvarchar)+',',
','+replace(a.RolseId,'''','')+',',
1)>0
for xml path('')),1,1,''))
FROM Sys_Users a
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货