sql函数中怎样定义一个递增变量？

[qin2006]

我要定义一个合并记录的函数，使原本结果
A AA1
A AA2
B BB1
B BB2
变成
A AA1,AA2
B BB1,BB2
下面的函数已经实现
create function Gettxt(@id char)
returns varchar(8000)
as
begin
declare @s varchar(8000)
set @s=''
select @s=@s +',' +txt from csdn where id=@id
--return @s
return stuff(@s,1,1,'')
end
go

现在要在合并记录处加上编号，如
A （1）AA1(2)AA2
请问该如何处理？

[liangCK]

create function Gettxt(@id char) 
returns varchar(8000) 
as 
begin 
declare @i int
declare @s varchar(8000) 
select @s='' ,@i=1
select @s=@s +',' +'(' +rtrim(@i) + ')'+txt,
       @i=@i+1
 from csdn where id=@id 
--return @s 
return stuff(@s,1,1,'') 
end 
go 

[pt1314917]

create function Gettxt(@id char) 
returns varchar(8000) 
as 
begin 
declare @s varchar(8000),@i int 
set @s='' 
set @i=1
select @s=@s +',(' +ltrim(@i)+')'+txt,@i=@i+1 from csdn where id=@id 
--return @s 
return stuff(@s,1,1,'') 
end 
go 

[Zoezs]

create function Gettxt(@id char) 
returns varchar(8000) 
as 
begin 
declare @s varchar(8000),@i int 
set @s='' 
set @i=1
select @s=@s +',(' +ltrim(@i)+')'+txt,@i=@i+1 from csdn where id=@id 
--return @s 
return stuff(@s,1,1,'') 
end 
go 

[chuifengde]

ALTER  function Gettxt(@id VARCHAR(20)) 
returns varchar(8000) 
as 
begin 
declare @s varchar(8000) ,@i INT 
select  @s='',@i=1 
select @s=@s+'('+ltrim(@i)+')'+txt,@i=@i+1 from csdn where id=@id 

return @s 
end 

[叶子]

速度都好快呀

[qin2006]

果然是高手如林，太感谢了！