SQL SERVER数据库拼接查询数据的方法

SQL SERVER拼接查询结果的方法

用‘/’分隔查询的语句

select BGID,WD_JCompany,WD_SCompany,WD_TCar,WD_SCar,WD_TemMin,WD_TemMax,WD_HemMin,WD_HemMax,WD_StartTime,WD_ServiceTime,WD_CollSpace,WD_TemAsk,WDID,WD_RecordCount,WD_RecordSpace,WD_MaxTime,WD_MinTime,SD_MaxTime,SD_MinTime,WD_StartTem = (stuff((select '/' + WD_StartTem from WD_DateReport where BGID = 
    a.BGID for xml path('')),1,1,'')),WD_EndTem = (stuff((select '/' + WD_EndTem from WD_DateReport where BGID = 
    a.BGID for xml path('')),1,1,'')),WD_StartHem = (stuff((select '/' + WD_StartHem from WD_DateReport where BGID = 
    a.BGID for xml path('')),1,1,'')), WD_EndHem = (stuff((select '/' + WD_EndHem from WD_DateReport where BGID = 
    a.BGID for xml path('')),1,1,''))  
	from WD_DateReport a group by BGID,WDID,WD_JCompany,WD_SCompany,WD_TCar,WD_SCar,WD_TemMin,WD_TemMax,WD_HemMin,WD_HemMax,WD_StartTime,WD_ServiceTime,WD_CollSpace,WD_TemAsk,WDID,WD_RecordCount,WD_RecordSpace,WD_MaxTime,WD_MinTime,SD_MaxTime,SD_MinTime

方法如下：

字段名 =(stuff((select '/' + 字段名 from 表名 where 条件 = 
    a.条件 for xml path('')),1,1,''))

详情请参照上面sqlserver语句

效果图：