ÇósqlÓï¾ä

ÎÒÏëµÃµ½    ±±¾©ÉϺ£ÐìÖÝÎ÷ÑÅͼ
ÈçºÎ¶Ô±í½øÐеü´úʵÏÖ£¿£¿


declare @t table(³ÇÊÐÃû³Æ varchar(10),Ò»µÈ½± int,¶þµÈ½± int,ÈýµÈ½± int)
insert into @t select '±±¾©',2,6,11 insert into @t select 'ÉϺ£',1,4,24
insert into @t select 'ÐìÖÝ',0,7,55 insert into @t select 'Î÷ÑÅͼ',3,5,32


declare @s1 varchar(8000)

--select @s1= ³ÇÊÐÃû³Æ  from @t
select @s1=isnull(@s1,'Ò»µÈ½±:')+isnull(³ÇÊÐÃû³Æ+ltrim(nullif(Ò»µÈ½±,0))+',','') from @t
select @s1
select * from @t

---

СÁº²»ÊÇдÁ˵ÄÂï

---

ÆÕͨµÄSQL ¶¯Ì¬Á´½Ó 
ÎÒ²»¶®°¡
Ò»¾ä»°¾Í·ÃÎÊÈ«²¿£¬Ì«ÉñÆæÁË

---

ÒýÓÃ

ÆÕͨµÄSQL ¶¯Ì¬Á´½Ó 
ÎÒ²»¶®°¡
Ò»¾ä»°¾Í·ÃÎÊÈ«²¿£¬Ì«ÉñÆæÁË

---

SQL code:
declare @t table(³ÇÊÐÃû³Æ varchar(10),Ò»µÈ½± int,¶þµÈ½± int,ÈýµÈ½± int)
insert into @t select '±±¾©',2,6,11 insert into @t select 'ÉϺ£',1,4,24
insert into @t select 'ÐìÖÝ',0,7,55 insert into @t select 'Î÷ÑÅͼ',3,5,32




DECLARE @STR VARCHAR(8000)

SELECT @STR=ISNULL(@STR+'','')+³ÇÊÐÃû³Æ from (SELECT DISTINCT ³ÇÊÐÃû³Æ from @t)AS T

SELECT @STR
/*----------------------------------------------------------------------------------------------------------