随笔分类 -  sql server

sqlserver将查询中一行内容转化为多行内容
摘要：WITH CTE AS( SELECT top 5 TaskID ,Attachments from [V_AllAccessoriesAompression])SELECT a.TaskID,c.Attachments FROM (SELECT TaskID,CONVERT(XML,'<R><V> 阅读全文
posted @ 2022-02-08 12:01 小小怪战士 阅读(915) 评论(0) 推荐(1)