create proc test
as
SELECT id=IDENTITY(int,1,1),ClassName
INTO #T_Temp0
FROM dbo.G_News_Class
ORDER BY AutoID
SELECT * FROM #T_Temp0
DROP TABLE #T_Temp0
dbo.G_News_Class 是自己的表,#T_Temp0 是临时表,