SQL Server中查询时显示行号的方法
Windows/.Net/MSSQL December 4th, 2006 536 ViewsSelect no=Identity(int,1,1),* Into #temptable From TableName –Order By SortField
Select * From #temptable –Where no>=6 And no < 10
Drop Table #temptable
Select no=Identity(int,1,1),* Into #temptable From TableName –Order By SortField
Select * From #temptable –Where no>=6 And no < 10
Drop Table #temptable
Recent Comments