select row_number() over( order by @@identity) as row 转载于:https://www.cnblogs.com/dashi/archive/2011/12/25/4034734.html