随笔分类 - SQL

摘要：REPLACE select [列],replace([列],'要查询的字符'，'查询到的字符所要修改的结果') from [表名] 阅读全文

posted @ 2022-06-18 15:41 kylinll 阅读(40) 评论(0) 推荐(0)

摘要：SELECT 字段1, [列名] = stuff(( SELECT ',' + [字段2] FROM aa t WHERE t.字段1 = aa.字段1 FOR xml path('')) , 1 , 1 , '') FROM aa GROUP BY 字段1 阅读全文

posted @ 2022-06-16 10:41 kylinll 阅读(196) 评论(0) 推荐(0)