create fuction f_str()
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+p_name from 表
return stuff(@str,1,1,'')
end
go--查询
select dbo.f_str() as '产品'
,avg(p_jiage) as '平均价格'
,sum(p_shuliang) as '总数量'
from 表
returns varchar(8000)
as
begin
declare @str varchar(8000)
set @str=''
select @str=@str+','+p_name from 表
return stuff(@str,1,1,'')
end
go--查询
select dbo.f_str() as '产品'
,avg(p_jiage) as '平均价格'
,sum(p_shuliang) as '总数量'
from 表
select @s=@s+',',avg(p_jiage),count(p_shuliang) from tablename
fuction 靠近有错误提示