SwePeso (3/28/2010)
Paul White NZ (3/28/2010)
Well, technically there is, sort of, but it is undocumented and not intended for use by end users.
+1 for that.
All records do have a "hidden" record identifier, when there is not primary key on the table. That's the way SQL Server distinguishes between two identical records.
Read more about what Kalen Delaney writes about this.
Is it actually a row identifier, like this is row 10? Reason I ask is that is what most people are looking for when they are asking about an internal rowid. Is that what this individual is asking, not sure.