Home Forums SQL Server 2008 SQL Server Newbies Clustered indexed primary key not in asc order when selected RE: Clustered indexed primary key not in asc order when selected

  • Sql Server will scan the table differently for the query's with and without the hints which is why you may be getting a different sort order..

    The only way to guarantee the order of the query is to use the ORDER BY regardless of previous results and expectations based upon those..

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe