如何在SQL中加逗号分隔的字符串？[复制]

您可以更动态地创建函数。请按照以下步骤

1. 创建一个给出逗号分隔值之和的函数

   CREATE FUNCTION GetToalOfCommaSeperatedVal

   (
   @commaSeperatedVal varchar(100)
   )
   RETURNS int
   AS
   BEGIN
   
   
   

   declare @sum intDECLARE @x XML SELECt @x = CAST('<A>'+ REPLACE(@commaSeperatedVal,',','</A><A>')+ '</A>' AS XML)SELECT @sum=sum(t.value('.', 'int'))   FROM @x.nodes('/A') AS x(t)

   return @sum
   END
   GO

2. 以以下方式执行“仅选择”命令

   select id,dbo.GetToalOfCommaSeperatedVal(value) from YOUR_TABLE