When SQLServer sorting recording and reading will affect the outcome?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

It is found that when doing the procedure, I use a stored procedure, when read second pages of results found there are many repetitive content with the first page,

Below to begin the test.:

Create table

create table abc
id int primary key identity(1,1),
forder int default 0
Table abc, only ID and Forder two column

Bulk insert 10 data, the first four is Forder 1, six is Forder 0

If the total data

Following the use of ranking query

This is the fourth conditions and results, taking the first 6 to 8 to get the results are not the same, ranking only to the Forder in ascending order, do not write the ID Case,

Who you have encountered this problem

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Darnell at November 23, 2013 - 7:55 PM