Monday, March 12, 2012

how to get RID of rows

thanks

Why exactly do you need the RID?

WesleyB

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

|||

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....

|||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,

No comments:

Post a Comment