用sql求得每行行号 第一种方法Select (Select Count(FA) From TableName Where FA <= A.FA) As 行号 , * From TableName A第二种方法select identity(int,1,1) as iid,* into #t from tableselect * from #tdrop table #t