update 多表操作

update t_borrow set fkid=b.noumber from (
select row_number() over (order by PublishTime asc)
as noumber,borrowId from t_borrow
) b
where b.BorrowId=t_borrow.BorrowId

posted @ 2015-12-24 10:10  595824023  阅读(212)  评论(0编辑  收藏  举报