select stuff((select ‘,‘+ CONVERT(VARCHAR(50),lateminute) from T_Attendance_Abnormal WHERE lateminute>0 for xml path(‘‘)),1,1,‘‘)
SQL 行转成字符串,隔开
原文:http://www.cnblogs.com/Kiss920Zz/p/7761992.html