declare @s nvarchar(4000)
select @s=N'',@表名=quotename(@表名)
select @s=@s+N','+quotename(name)
from syscolumns
where id=object_id(@表名)
and isnumeric(name)=1
order by name
exec(N'select name'+@s+N',sumall from '+@表名) --拼写错误,将select误写成seelct了
declare @s nvarchar(4000)
select @s=N'',@表名=quotename(@表名)
select @s=@s+N','+quotename(name)
from syscolumns
where id=object_id(@表名)
and isnumeric(name)=1
order by name
exec(N'seelct name'+@s+N',sumall from '+@表名)