修改forxml连接字段

chi8708 · May 8, 2024 · 2477c5a · 2477c5a
1 parent 493883d
commit 2477c5a
Showing 1 changed file with 5 additions and 1 deletion.
diff --git a/6.字符串逗号分隔返回table.sql b/6.字符串逗号分隔返回table.sql
@@ -10,4 +10,8 @@ ALTER  function   [dbo].[Dhf_split](@c   varchar(2000),@split   varchar(2))
          end   
        insert   @t(col)   values   (@c)   
        return   
-     end 
+     end 
+
+
+
+将多行某列值合并为逗号分隔的一列  SELECT STUFF((SELECT ','+name FROM 表名 for xml path('')),1,1,'')