sql stuff拼接字符串的用法

图2sql，只是很普通的sql

select * from Access_Statistics where SFZH=‘152923199608242120‘ and CONVERT(varchar(100), SKSJ, 112)=‘20161015‘ order by SKSJ

图1sql，用了stuff拼接

select dz.XM as 姓名,dz.JSZH as 卡号,[刷卡时间]=stuff((select ‘,‘+substring(CONVERT(varchar(100), SKSJ, 8),0,6)
 from Access_Statistics  where SFZH=mj.SFZH and  
 CONVERT(varchar(100),SKSJ, 112)=‘20161015‘ and SFZH=‘152923199608242120‘ order by SKSJ for xml path(‘‘) ), 1, 1, ‘‘) 
 from Access_Statistics mj
inner join Readers dz on dz.SFZH = mj.SFZH
inner join XX04 bj on dz.BJBH=bj.BJBH
where CONVERT(varchar(100), mj.SKSJ, 112)=‘20161015‘ and mj.SFZH=‘152923199608242120‘
group by mj.SFZH,dz.XM,dz.JSZH

sql stuff拼接字符串的用法

标签：