SQL Server update one column line number

Note : Reference from http://blog.csdn.net/lenovouser/article/details/52281726

Query Displays line number:

1 SELECT 2      Over (ORDER by as rowNumber3from4     table_name ;

Update one column line number:

1 UPDATEtable_name2 SETNew_row=T1.rowid3  from4     (5          　　　　 SelectTABLE_PK,6Row_number () Over(ORDER  byORDERBY_ID) asrowID7      from8 table_name9 )Ten) asT1 One WHERE AT1.table_pk=TABLE_NAME.TABLE_PK;

SQL Server update one column line number