USE Northwind
GO

DECLARE @TABLE_NAME sysname
SET @TABLE_NAME = 'Orders'

SELECT SQL 
  FROM (
	 SELECT TABLE_NAME, 1 AS SQL_GROUP, 1 AS ROW_ORDER 
	      , ' SELECT    '+COLUMN_NAME AS SQL
  	   FROM INFORMATION_SCHEMA.Columns
 	  WHERE TABLE_NAME = @TABLE_NAME
   	    AND ORDINAL_POSITION=1
      UNION ALL
	 SELECT TABLE_NAME, 2 AS SQL_GROUP, ORDINAL_POSITION AS ROW_ORDER 
	      , '        ,  '+COLUMN_NAME AS SQL
	   FROM INFORMATION_SCHEMA.Columns
 	  WHERE TABLE_NAME = @TABLE_NAME
            AND ORDINAL_POSITION<>1
      UNION ALL
	 SELECT TABLE_NAME, 3 AS SQL_GROUP, ORDINAL_POSITION AS ROW_ORDER 
	      , '   FROM  '+TABLE_NAME AS SQL
	   FROM INFORMATION_SCHEMA.Columns
	  WHERE TABLE_NAME = @TABLE_NAME
	    AND ORDINAL_POSITION=1) AS XXX
ORDER BY TABLE_NAME, SQL_GROUP, ROW_ORDER