22,209
社区成员
发帖
与我相关
我的任务
分享
create table test
(
id int identity(1,1),
name varchar(10),
)
insert into test values('A')
insert into test values('B')
insert into test values('C')
declare @names varchar(100)=''
select @names=@names+','+name from test
select stuff(@names,1,1,'') name
name
--------------------
A,B,C
(1 row(s) affected)
create table test
(
id int identity(1,1),
name varchar(10),
)
insert into test values('A')
insert into test values('B')
insert into test values('C')
select stuff((select ','+name from test for xml path('')),1,1,'') name
name
--------------------
A,B,C
(1 row(s) affected)
create table test
(
id int identity(1,1),
name varchar(10),
)
go
insert into test values('A')
insert into test values('B')
insert into test values('C')
go
declare @str varchar(1000)
select @str = isnull(@str+',','')+name from test
print @str
drop table test
/*****************
A,B,C
select stuff((select ','+name from test for xml path('')),1,1,'')