The use of SQL stuff stitching strings

To display Figure 2 as a method of Figure 1: The stuff function is used, and the time shown in Figure 1 is truncated.

Figure 2sql, just plain SQL

Select  from where Sfzh='152923199608242120' and CONVERT (varchar)=' 20161015 ' ORDER by SKSJ

Figure 1sql, using the stuff stitching

SelectDz. Xm asName, DZ. Jszh asCard number, [Swipe Time]=stuff (Select ','+substring (CONVERT (varchar ( -), SKSJ,8),0,6)  fromAccess_statisticswhereSfzh=MJ. Sfzh and CONVERT (varchar ( -), SKSJ, the)='20161015'and sfzh='152923199608242120'ORDER BY SKSJ forXML Path ("') ),1,1,"')   fromaccess_statistics Mjinner join Readers dz on DZ. Sfzh=MJ. Sfzhinner join XX04 BJ on DZ. BJBH=BJ. BJBHwhereCONVERT (varchar ( -), MJ. SKSJ, the)='20161015'and MJ. Sfzh='152923199608242120'GROUP BY MJ. Sfzh,dz. Xm,dz. Jszh

The use of SQL stuff stitching strings