SQL的一个查询中增多一个序列号三种不同的方法

1.select IDENTITY(INT,1,1) as seq,* INTO tmpTableName from pr_CheckoutInforselect * from tmpTableNamedrop table tmpTableName2.SELECT (SELECT COUNT(InnerID) FROM pr_CheckoutInfor AS tbl1WHERE tbl1.InnerID<=tbl2.InnerID) as seq,*FROM pr_CheckoutInfor AS tbl2 3.select seq=Row_number() Over(order by getdate()),* from pr_CheckoutInfor

?