SQL server将多列值拼接在一起，成为另一个栏位值

拼接CAST (栏位名 AS VARCHAR)

select curr_station station,CAST (year(modifydate) AS VARCHAR) +CAST ('\' AS VARCHAR)+ CAST (Right(100 + Month(modifydate), 2) AS VARCHAR) path from FLOW where sno = '003D' and curr_station in ('WOL4')

在小于10的月份前加0

Right(100 + Month(a.modifydate), 2) 

获取日期中的year

year(modifydate)