--查询行号
select row_number()over(order by CHECKTIME )as RowNum,*from CHECKINOUT
--更新id列为行号
update CHECKINOUT set id=t.rowId from
(select CHECKTIME, ROW_NUMBER() over(Order by CHECKTIME) as rowId from CHECKINOUT ) as t
where t.CHECKTIME = CHECKINOUT.CHECKTIME
原文：http://www.cnblogs.com/arnoid/p/4226210.html