谁能给我个sql2000的连加字符串的聚集函数

select sum(cast(price as decimal(18,2))) from tablename

以上，希望对你有所帮助！

1、创建自定义函数f_getStirng
create function f_getStirng(@A varchar(8000))
returns varchar(8000)
as
Begin
Declare @Temp_B varchar(8000),@B varchar(8000)
Set @B=''
declare cur_test cursor for
Select @A from tablename
open cur_test
fetch next from cur_test into @Temp_B
While @@Fetch_status=0
Begin
set @B=@B+@Temp_B
fetch next from cur_test into @Temp_B
End
close cur_test deallocate cur_test
return @B
end

2、执行语句
select dbo.f_getStirng(Price) from tablename

select sum(列名) as 价格 from tablename