NEXT AND PREVIOUS RECORDS
-
IS THERE ANY PROVISION TO ASCERTAIN NEXT AND PREVIOUS RECORD IN SQL SERVER 2000 ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
-
IS THERE ANY PROVISION TO ASCERTAIN NEXT AND PREVIOUS RECORD IN SQL SERVER 2000 ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
Sonia Gupta wrote:
IS THERE ANY PROVISION TO ASCERTAIN NEXT AND PREVIOUS RECORD IN SQL SERVER 2000 ?
Databases are set based. There is no concept of next and previous row. Any database that does this is working on a fiction. ORDER BY can be used to impose an order on the result set, but again this is a fiction to make things easier for the calling application. It may appear that a database is returning data in a specific order all the time, but this is merely a side-effect of the physical implementation and not something you can rely on.
Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog
-
IS THERE ANY PROVISION TO ASCERTAIN NEXT AND PREVIOUS RECORD IN SQL SERVER 2000 ?
Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.
Don't shout. Please use mixed case. You can find next and previous records, but the queries are likely to be fairly "hairy". As Colin states, SQL is set based so you have to figure out how to work on the set.
Deja View - the feeling that you've seen this post before.
-
Don't shout. Please use mixed case. You can find next and previous records, but the queries are likely to be fairly "hairy". As Colin states, SQL is set based so you have to figure out how to work on the set.
Deja View - the feeling that you've seen this post before.
oK PeTE, iT's miXeD CAsE fRoM heRE oN In. :)
-
oK PeTE, iT's miXeD CAsE fRoM heRE oN In. :)
That's much better.
Deja View - the feeling that you've seen this post before.