RowVersion

Create Table Orders (

    OrderID int not null identity(1,1)

        Constraint PK_Orders Primary Key

    , ProductName varchar(50) not null

    , Quantity int not null

    , RowRevision rowversion

)

Insert Into Orders(ProductName, Quantity)

Values ('Widget-Dongles', 13)

Insert Into Orders(ProductName, Quantity)

Values ('test 2', 15)

select OrderID, ProductName, Quantity, RowRevision, cast(RowRevision as int)

from orders order by RowRevision desc