select ROW_NUMBER() Over ( ORDER BY UserID) as rowId,UserID,UserName from Users 转载于:https://www.cnblogs.com/Donkey/archive/2010/07/15/1777797.html