select IDENTITY(INT,1,1) as seq,* INTO tmpTableName from pr_CheckoutInfor
select * from tmpTableName
drop table tmpTableName
SELECT (SELECT COUNT(InnerID) FROM pr_CheckoutInfor AS tbl1
WHERE tbl1.InnerID<=tbl2.InnerID) as seq,*
FROM pr_CheckoutInfor AS tbl2
select seq=Row_number() Over(order by getdate()),* from pr_CheckoutInfor
我选择的最后一个。?不知道这三个方法的性能那个最好的呢/
如果是大批量数据?