locked
how to get RID of rows RRS feed

Answers

  • 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,
    Thursday, August 23, 2007 4:24 AM

All replies

  • Why exactly do you need the RID?

     

     

    WesleyB

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

    Wednesday, August 22, 2007 6:28 PM
  • 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....

     

     

     

     

     

    Thursday, August 23, 2007 1:41 AM
  • 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,
    Thursday, August 23, 2007 4:24 AM