declare @s varchar(8000)
select @s = isnull(@s,'')+'a='+ltrim(a)+',b='+b+',c='+c+',d='+d from temptable
select @s

declare @s varchar(8000)
select @s = isnull(@s+',','')+'a='+ltrim(a)+',b='+b+',c='+c+',d='+d from temptable
select @s

create table temptable 
( 
a int, 
b varchar(10), 
c varchar(10), 
d varchar(10) 
) 


insert into temptable values(1,'我1','是1','谁1') 
insert into temptable values(2,'我2','是2','谁2') 
insert into temptable values(3,'我3','是3','谁3') 
insert into temptable values(4,'我4','是4','谁4') 

declare @str varchar(1000)
set @str=''
select @str=@str+'a='+cast(a as varchar(12))+',b='+b+',c='+c+',d='+d+',' from temptable
select left(@str,len(@str)-1)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a=1,b=我1,c=是1,d=谁1,a=2,b=我2,c=是2,d=谁2,a=3,b=我3,c=是3,d=谁3,a=4,b=我4,c=是4,d=谁4

(1 行受影响)

if object_id('tempdb.dbo.#T') is not null drop table #T
create table #T
(
a int,
b varchar(10),
c varchar(10),
d varchar(10)
)

set nocount on

insert into #T values(1,'我1','是1','谁1')
insert into #T values(2,'我2','是2','谁2')
insert into #T values(3,'我3','是3','谁3')
insert into #T values(4,'我4','是4','谁4')

declare @sql nvarchar(max)
select @sql=isnull(@sql+char(10),'')+'a='+ltrim(a)+',b='+b+',c='+c+',d='+d from #T
print @SQL
/*
a=1,b=我1,c=是1,d=谁1
a=2,b=我2,c=是2,d=谁2
a=3,b=我3,c=是3,d=谁3
a=4,b=我4,c=是4,d=谁4
*/

set nocount off

create table temptable 
( 
a int, 
b varchar(10), 
c varchar(10), 
d varchar(10) 
) 


insert into temptable values(1,'我1','是1','谁1') 
insert into temptable values(2,'我2','是2','谁2') 
insert into temptable values(3,'我3','是3','谁3') 
insert into temptable values(4,'我4','是4','谁4') 


declare @sql varchar(8000)
set @sql=''
select @sql=@sql+''','+name+'='''+'+cast('+name+' as varchar(8000))+' from syscolumns where id=object_id('temptable') order by colid
select @sql='declare @str varchar(8000) set @str=''''select @str=@str+'+stuff(stuff(@sql,len(@sql),1,''),2,1,'')+' from temptable select @str'
exec(@sql)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a=1,b=我1,c=是1,d=谁1a=2,b=我2,c=是2,d=谁2a=3,b=我3,c=是3,d=谁3a=4,b=我4,c=是4,d=谁4

(1 行受影响)

declare @sql varchar(8000)
set @sql=''
select @sql=@sql+''','+name+'='''+'+cast('+name+' as varchar(8000))+' from syscolumns where id=object_id('temptable') order by colid
select @sql='declare @str varchar(8000) set @str=''''select @str=@str+'+stuff(stuff(@sql,len(@sql),1,''),2,1,'')+' from temptable select @str'
exec(@sql)