SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
GO
SET ANSI_NULLS ON
GO
ALTER FUNCTION dbo.SumFace(参数 参数类型)
RETURNS VARCHAR(500)
AS
BEGIN
DECLARE 定义变量 类型与长度
SET 变量=''
SELECT 变量=变量+','+cast(字段名 as 类型) FROM 表名 WHERE 条件
RETURN stuff(变量,1,1,'')
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO