sqlserver中获取行号使用Row_number函数,如:
SELECT ROW_NUMBER() OVER(ORDER BY CREATEDTIME DESC) AS NUMBERROW,id,initid,name,customerrole,CREATEDTIME FROM PARTY_CUSTOMER
如果只是单纯使用行号,而不需要order by 则可写为如下形式:
SELECT ROW_NUMBER() OVER(select 0) AS NUMBERROW,id,initid,name,customerrole,CREATEDTIME FROM PARTY_CUSTOMER