表名为 BillInfo,BillId为表中字段(任意字段均可)
SELECT ROW_NUMBER() OVER(ORDER BY BillId) as seqNum ,* FROM BillInfo