请问一下sql server 中select 出的结果可以直接连成一个字符串吗

[lfrsx]

假如select name from student 的结果有两个名字，现在我想将这两个名字连成一个字符串（最好中间有个逗号），是不没有这样的函数啊

[kaikai_kk]

可以写一个函数

[Limpire]

declare @name varchar(8000)
select @name=isnull(@name+',','')+name from syscolumns where id=object_id('sysobjects')
select @name
/*
base_schema_ver,cache,category,crdate,deltrig,ftcatid,id,indexdel,info,instrig,name,parent_obj,refdate,replinfo,schema_ver,seltrig,stats_schema_ver,status,sysstat,type,uid,updtrig,userstat,version,xtype
*/

[hui_hui_2007]

不用函数吧。select 语句中直接实现
select 字段一 + ',' + 字段二
from 表名

[huangfu_km]

declare @col as nvarchar(1024)
set @col=''
select @col = @col+','+[a].[Column]
from(select name as [Column] from student)as a
select right(@col,len(@col)-1) as nameList

[huangfu_km]

declare @col as nvarchar(1024)
set @col=''
select @col = @col+','+ name from student --递归
select right(@col,len(@col)-1) as nameList

递归Select变量在做动态交叉表中经常用到的

[律己修心]

declare @a varchar(8000)
select @a=isnull(@a+',','')+[name] from student 
select @a

[cdzch]

select name1+name2 as name from student

[zzyyc]

select a1+','+a2 as name from tb

[jhwcd]

[Quote=引用 2 楼 Limpire 的回复:]
SQL codedeclare @name varchar(8000)
select @name=isnull(@name+',','')+name from syscolumns where id=object_id('sysobjects')
select @name
/*
base_schema_ver,cache,category,crdate,deltrig,ftcatid,id,indexdel,info,instrig,name,parent_obj,refdate,replinfo,schema_ver,seltrig,stats_schema_ver,status,sysstat,type,uid,updtrig,userstat,version,xtype
*/
[/Quote]

[Dragon_pan]

declare @stuTb table (uid  int , stuName varchar(50))

Insert Into @stuTb 
select 1,'张三'
union 
select 2,'李四'

declare @a varchar(8000)
select @a=isnull(@a+',','')+stuName from @stuTb 
select @a

张三,李四
（所影响的行数为 1 行）

[正宗老冉]

两个 ISNULL() 相加是最可行的方案。