select *,row_number()over(order by id) as number_id from [dbo].tb_pccw20140213
row_number()over(order by id) SQL顺序排列
原文：http://www.cnblogs.com/wqing/p/3559201.html
