法1:SELECT ID ,
rownumb = ROW_NUMBER() OVER ( ORDER BY ID DESC )
FROM dbo.AM_Project P
WHERE IsDel = 1;
法2: SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC ) AS rownum, *
FROM dbo.AM_Project P
WHERE IsDel = 1;
INTO #temptable
FROM dbo.AM_Project P
WHERE IsDel = 1;
SELECT *
FROM #temptable;
rownumb = ROW_NUMBER() OVER ( ORDER BY ID DESC )
FROM dbo.AM_Project P
WHERE IsDel = 1;
法2: SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC ) AS rownum, *
FROM dbo.AM_Project P
WHERE IsDel = 1;
法3: DROP TABLE #temptable;
SELECT IDENTITY( INT, 1,1 ) AS 行号 , *INTO #temptable
FROM dbo.AM_Project P
WHERE IsDel = 1;
SELECT *
FROM #temptable;