摘要： SELECT * INTO #TempStudent FROM(SELECT id, ROW_NUMBER() OVER(ORDER BY id) RowNum FROM dbo.student) NewTUPDATE dbo.student SET score=#TempStudent.RowN... 阅读全文