随笔分类 -  Sql Server

SqlService Date 格式化
摘要：CONVERT(VARCHAR(10), FRI.INVOICE_DATE, 120) AS CREATED_ON, CONVERT(VARCHAR(7), FRI.INVOICE_DATE, 120) AS CREATED_ON, STR(YEAR(FRI.INVOICE_DATE), 4) +... 阅读全文
posted @ 2018-02-10 16:39 Bob.Xie 阅读(457) 评论(0) 推荐(0) 编辑
将检索出来的列按逗号拼接起来
摘要：(STUFF((select ',' + USER_NAME from TBL_BIZ_TRSBILLS_DETAIL where TRANSPORT_CODE = TB.TRANSPORT_CODE and USER_TYPE = '司机' for xml path('')),1,1,'' )) 阅读全文
posted @ 2017-08-24 22:18 Bob.Xie 阅读(273) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示