一个返回字符串的问题,大侠们帮看看

[涛声宜旧]

例:表1(A是表1的唯一字段)
A
2
3
5
7
kl
中国


要求得到字符串 A,2,3,5,7,kl,中国

写存储过程,谢了

[wangdehao]

declare @str varchar(8000)
set @str =''

select @str =@str +A from 表1

select @str

[rookie_one]

ls正解~

[wangdehao]

declare @str varchar(8000)
set @str =''

select @str =@str +','+A from 表1

select stuff(@str,1,1,'')

[gahade]

create proc up_t1
as
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+A+',' from 表1
select @sql=left(@sql,len(@sql)-1)
print @sql

[rookie_one]

declare @str varchar(8000)
set @str =''
select @str =@str +','+A from 表1
select stuff(@str,1,1,'')

[xiaoku]

create proc Sp_test @s varchar(1000)output
as
begin
select @s =''
select @s =@s +',' +A from tbl
select @s =substring(@s,1,len(@s)-1)
return(@s)
end