declare @sql varchar(8000)
set @sql = ''
select @sql = @sql + [name] + ';' from [sample]
set @sql = left(@sql,len(@sql) - 1)
set @sql = ''
select @sql = @sql + [name] + ';' from [sample]
set @sql = left(@sql,len(@sql) - 1)
declare @s varchar(8000)
set @s=''
select @s=@s+';'+[name] from sample
set @s=substring(@s,2,8000)
select @s
id为你表中的标识字段
select name=((select top 1 name from sample order by id )+';'+a.name+';'+b.name) from sample a join sample b on b.id=a.id+1
id为你表中的标识字段
set @s=''
select @s=@s+';'+[name] from sample
set @s=substring(@s,2,8000)
select @s