My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/What is the position of a row ?
The new RSS feed is here
The simple answer is there isn't
one.
If you insert 1000 rows into a table and then want to get back the 43rd row
you inserted you can't. You can read through all rows and return the 43rd one
that the database reads from the table but that is not the same thing.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/What is the position of a row ?