SqlServer 知识标记

1.select查询结果，增加一列自增的列来记录行数

example:SELECT ROW_NUMBER() OVER (ORDER BY MemBas_memberID) AS ID,* FROM MemberBasic