摘要： 第一种例子SELECT ROW_NUMBER() OVER (ORDER BY Id) AS Rowinto #tmpFROM PersonDECLARE @beginNumber intset @beginNumber = 1declare @endNumber intselect @endNumber = COUNT(*) from Personwhile(@beginNumber <= @endNumber)begin select Row from #tmp where Row = @beginNumber set @beginNumber = @beginNumber + 1 阅读全文