October 15, 2008 at 5:51 am
Check the following links
October 15, 2008 at 6:49 am
Thank you
That's exactly what I was looking for
October 16, 2008 at 2:43 am
though, is there a ROWID function in Sql Server?
Some say that this is very usefull (in oracle or others..)
October 16, 2008 at 2:49 am
though, is there a ROWID function in Sql Server?
Not directly, no. The closest is the identity column and the ROW_NUMBER function, though neither is a direct replacement.
You can't easily get at a row's physical location. (page or slot) and you shouldn't need to. Besides, they can change.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply