--动态生成SQL语句:declare @tbname sysname
set @tbname='要查询的表名'--查询处理
declare @s varchar(8000)
set @s=''
select @s=@s+',['+name+']' from syscolumns
where name<>'id' and object_name(id)=@tbname
order by colid
set @s=stuff(@s,1,1,'')
exec('select '+@s+' from ['+@tbname+']')
set @tbname='要查询的表名'--查询处理
declare @s varchar(8000)
set @s=''
select @s=@s+',['+name+']' from syscolumns
where name<>'id' and object_name(id)=@tbname
order by colid
set @s=stuff(@s,1,1,'')
exec('select '+@s+' from ['+@tbname+']')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货