how to get RID of rows

Question

thanks

Answer 1

Why exactly do you need the RID?

 

 

WesleyB

Visit my SQL Server weblog @ http://dis4ea.blogspot.com

Answer 2

HI WesleyB

 

I have no concret need now.

 

Just want to know  where it store?

 

I use dbcc page command to oversee the structure of the data page.

 

I can see many data row .... but can't see the RID....

 

 

 

 

 

Answer 3

The RID is not stored. It is calculated from the PageId and the SlotId on the page, i.e. Slot 17 on Page 1:29 has RID 1:29:17.

Thanks,