又遇一问题，求解！

[kart15]

有一段字符：@zd='ID,Names,banner,age'

在T-sql中如何讲上述字符替换成‘min(ID) ID,min(Names) Names,min(banner) banner,min(age) age’

注：@zd可能有很多个','

请问这个得怎么整！

[飘零一叶]

DECLARE @zd VARCHAR(MAX)
SET @zd=','+'ID,Names,banner,age'+','
SET @zd=REPLACE(@zd,',ID,',',MIN(ID),')
..............
..............

[kart15]

[Quote=引用 1 楼 dlut_liuq 的回复:]
SQL code
DECLARE @zd VARCHAR(MAX)
SET @zd=','+'ID,Names,banner,age'+','
SET @zd=REPLACE(@zd,',ID,',',MIN(ID),')
..............
..............
[/Quote]
问题是不知道是否是ID，Names...
在c#中利用循环来做，我想这里应该也得用循环吧！

但T-sql语句不熟悉，请赐教

[AcHerat]

create function f_str(@str varchar(1000))
returns varchar(1000)
as
begin
declare @s1 varchar(1000)
declare @s2 varchar(1000)
declare @id int
set @s1 = @str + ','
set @id = charindex(',',@s1)
set @s2 = ''
while(len(@s1)>0)
	begin
		set @s2 = @s2 + 'min('+substring(@s1,1,@id-1)+')'+','
		set @s1 = substring(@s1,@id+1,len(@s1))
		set @id = charindex(',',@s1)
	end
set @s2 = stuff(@s2,len(@s2),1,'')
return @s2
end
go

select dbo.f_str('id,ic,ar,aga')lie

drop function f_str

lie
--------------------------------------------
min(id),min(ic),min(ar),min(aga)

[AcHerat]

create function f_str(@str varchar(1000))
returns varchar(1000)
as
begin
declare @s1 varchar(1000)
declare @s2 varchar(1000)
declare @id int
set @s1 = @str + ','
set @id = charindex(',',@s1)
set @s2 = ''
while(len(@s1)>0)
	begin
		set @s2 = @s2 + 'min('+substring(@s1,1,@id-1)+') '+substring(@s1,1,@id-1)+','
		set @s1 = substring(@s1,@id+1,len(@s1))
		set @id = charindex(',',@s1)
	end
set @s2 = stuff(@s2,len(@s2),1,'')
return @s2
end
go

select dbo.f_str('id,ic,ar,aga')lie

drop function f_str

lie
------------------------------------------------------
min(id) id,min(ic) ic,min(ar) ar,min(aga) aga

(1 行受影响)

[飘零一叶]

DECLARE @zd VARCHAR(MAX),@tm VARCHAR(MAX),@r VARCHAR(MAX)
SET @zd='ID,Names,banner,age'
while CHARINDEX(',',@zd)>0
begin
     set @tm=SUBSTRING(@zd,1,CHARINDEX(',',@zd)-1)
     set @tm='min('+@tm+') '+@tm+''
     set @r=ISNULL(@r+',','')+@tm
     print @r
     set @zd=STUFF(@zd,1,CHARINDEX(',',@zd),'')
end
set @zd='min('+@zd+') '+@zd+''
select @r+','+@zd
-----------------
(无列名)
min(ID) ID,min(Names) Names,min(banner) banner,min(age) age