SqlServer 知识标记

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

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

posted @ 2014-08-19 13:56    阅读(143)  评论(0编辑  收藏  举报