SELECT
	co1,
	col2,
	-- etc...
	colN
FROM
	YourTable
ORDER BY
	col1 ASC,
	col2 ASC,
	-- etc...
	colN ASC

SELECT
	co1,
	col2,
	-- etc...
	colN
FROM
	YourTable
ORDER BY
	1,2,3,4,
	-- etc
	N

SELECT ','+COLUMN_NAME FROM INFORMATION_SCHEMA.[COLUMNS] 
WHERE TABLE_NAME = 'YourTabelNameHere' ORDER BY ORDINAL_POSITION
FOR XML PATH('')

;WITH N(n) AS
( SELECT 1 UNION ALL SELECT n+1 FROM N WHERE n < 1000)
SELECT ',' AS [text()],n AS [text()] FROM N 
FOR XML PATH('') OPTION (MAXRECURSION 0);

quote:

---

Originally posted by zhshqzyc

I have many columns. List all is not practical.

---