create procedure getstr
@reStr varchar(1000) output
as
declare @str varchar(1000)
select @str=''
select @str=@str+[name]+',' from tablename
select @str=left(@str,len(@str)-1))
select @reStr=@str
return
@reStr varchar(1000) output
as
declare @str varchar(1000)
select @str=''
select @str=@str+[name]+',' from tablename
select @str=left(@str,len(@str)-1))
select @reStr=@str
return
create procedure getstr
@reStr varchar(1000) output
as
declare @str varchar(1000)
select @str=''
select @str=@str+[name]+',' from tablename
select @str=left(@str,len(@str)-1)
select @reStr=@str
return
set @s=''
select @s=@s+','+name from 表
select name1=stuff(@s,1,1,'')
set @s = ''
select @s = @s + ',' + name from 表
set @s = stuff(@s,1,1,'')
print @s