declare @s nvarchar(400) select @s=isnull(@s+',','')+quotename(Name) from syscolumns where ID=object_id('table') order by colid exec('select '+@s+' from table')
declare @s nvarchar(400) select @s=isnull(@s+',','')+quotename(Name) from syscolumns where ID=object_id('table') and Name!='ID'order by colid exec('select '+@s+' from table')
select @s=isnull(@s+',','')+quotename(Name) from syscolumns where ID=object_id('table') order by colid
exec('select '+@s+' from table')
select @s=isnull(@s+',','')+quotename(Name) from syscolumns where ID=object_id('table') and Name!='ID'order by colid
exec('select '+@s+' from table')