SQL 行转成字符串,隔开

select stuff((select ','+ CONVERT(VARCHAR(50),lateminute) from T_Attendance_Abnormal WHERE lateminute>0 for xml path('')),1,1,'')

 

posted @ 2017-10-31 15:59  日月当空  阅读(628)  评论(0编辑  收藏  举报