取出資料時自動增加序號

SELECT S_NO = IDENTITY(INT, 1, 1), *
INTO #TempTable
FROM ( SELECT TOP 20 * FROM MARKSHU) A

SELECT * FROM #TempTable
DROP TABLE #TempTable