select 
  case WHEN ca.mincol = c.colorder THEN 'SELECT [' ELSE '  [' END
  +c.[name]
  +case WHEN ca.maxcol = c.colorder THEN ']'+char(10)+'FROM ['+o.[name]+']' ELSE '],' END
from syscolumns c 
join sysobjects o on c.id = o.id
cross apply (select max(colorder) as maxcol, min(colorder) as mincol from syscolumns c2 where c2.id = o.id) as ca
where o.[name] = 'TableName'
order by c.colorder