datatable 转字符串

--select stuff ((SELECT ','+bu from DT_SalesBooking group by bu for xml path('')),1,1,'')
--select stuff ((SELECT DT_FY+ right(cast(power(10,2) as varchar)+DT_PD,2) from DT_SalesBooking group by DT_FY,DT_PD for xml path('')),1,1,'')
--select cast(DT_FY AS VARCHAR)+right(cast(power(10,2) as varchar)+DT_PD,2) from DT_SalesBooking

原文地址:https://www.cnblogs.com/yyzyou/p/4778635.html