列的顺序:declare @sql varchar(8000) set @sql='' select @sql=@sql+','+name 列 from syscolumns where id=object_id('表名') order by newid()set @sql=substring(@sql,2,8000)exec('select '+@sql+' from 表名')
o,多了“列”字 declare @sql varchar(8000) set @sql='' select @sql=@sql+','+name from syscolumns where id=object_id('表名') order by newid()set @sql=substring(@sql,2,8000)exec('select '+@sql+' from 表名')
declare @colStr varchar(1000) select @colStr='' select @colStr=@colStr+','+[name] from (select top 100 percent name from syscolumns where id=object_id('表') order by newid()) new select @colStr=stuff(@colStr,1,1,'')exec('select '+@colStr+' from 表 ')
set @sql=''
select @sql=@sql+','+name 列 from syscolumns where id=object_id('表名') order by newid()set @sql=substring(@sql,2,8000)exec('select '+@sql+' from 表名')
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+','+name from syscolumns where id=object_id('表名') order by newid()set @sql=substring(@sql,2,8000)exec('select '+@sql+' from 表名')
select @colStr=''
select @colStr=@colStr+','+[name]
from (select top 100 percent name from syscolumns where id=object_id('表') order by newid()) new
select @colStr=stuff(@colStr,1,1,'')exec('select '+@colStr+' from 表 ')