表名为 BillInfo,BillId为表中字段(任意字段均可)
SELECT ROW_NUMBER() OVER(ORDER BY BillId) as seqNum ,* FROM BillInfo
表名为 BillInfo,BillId为表中字段(任意字段均可)
SELECT ROW_NUMBER() OVER(ORDER BY BillId) as seqNum ,* FROM BillInfo
转载于:https://www.cnblogs.com/DaGuang/archive/2009/06/23/1509544.html