update T1 set T1.NextKey = T2.Key from TableA T1, TableA T2 whereT2.Index = T1.Index + 1
update起别名
原文：http://www.cnblogs.com/panqingqiang/p/4543850.html
