declare @s varchar(1000)select @s=isnull(@s+',','')+列1 from tb1select @s
declare @sql nvarchar(1000) set @sql='' select @sql=@sql+','+列1 from TB1
---测试数据--- if object_id('[tb1]') is not null drop table [tb1] go create table [tb1]([列1] varchar(1)) insert [tb1] select 'a' union all select 'b' union all select 'c' union all select 'd'
---查询--- declare @s varchar(1000)select @s=isnull(@s+',','')+列1 from tb1select @s as 列1 /** 列1 ------------------------------------ a,b,c,d(所影响的行数为 1 行) **/
create table #TB1 ( col char(10) ) insert into #TB1 select 'a' insert into #TB1 select 'b' insert into #TB1 select 'c' insert into #TB1 select 'd' declare @sql nvarchar(1000) set @sql='' select @sql=@sql+','+col from #TB1 select stuff(@sql,1,1,'') ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- a ,b ,c ,d (1 行受影响)
declare @str varchar(1000) select @str = @str + ',' + cast(col1 as varchar) from tb set right(@str , len(@str) - 1) select @str
set @sql=''
select @sql=@sql+','+列1 from TB1
if object_id('[tb1]') is not null drop table [tb1]
go
create table [tb1]([列1] varchar(1))
insert [tb1]
select 'a' union all
select 'b' union all
select 'c' union all
select 'd'
---查询---
declare @s varchar(1000)select @s=isnull(@s+',','')+列1 from tb1select @s as 列1
/**
列1
------------------------------------
a,b,c,d(所影响的行数为 1 行)
**/
(
col char(10)
)
insert into #TB1 select 'a'
insert into #TB1 select 'b'
insert into #TB1 select 'c'
insert into #TB1 select 'd'
declare @sql nvarchar(1000)
set @sql=''
select @sql=@sql+','+col from #TB1
select stuff(@sql,1,1,'')
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a ,b ,c ,d (1 行受影响)
declare @str varchar(1000)
select @str = @str + ',' + cast(col1 as varchar) from tb
set right(@str , len(@str) - 1)
select @str