日期:2014-05-17 浏览次数:20679 次
;with t as ( select *, t.c, row_number() over(order by 列 ) rownum from 表 cross join ( select MAX(列) as c from 表 )t where 列 is null ) update t set 列 = c+ rownum