rv.sql

declare @t table(id int identity primary key, name varchar(20), rv rowversion)

insert into @t (name) values('Moe')
insert into @t (name) values('Larry')
insert into @t (name) values('Curly')

select * from @t order by rv desc;

3	Curly	0x00000000000007EE
2	Larry	0x00000000000007ED
1	Moe	0x00000000000007EC

update @t set name = 'Moe Howard' where id = 1;

select * from @t order by rv desc;


1	Moe Howard	0x00000000000007EF
3	Curly		0x00000000000007EE
2	Larry		0x00000000000007ED