PK not ordered

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

A table in SQL CE contains a column (integer) composing the PK.
When I execute a SQL Query like :

SELECT * FROM MyTable

I get the data, but the column composing the PK are not ordered:

1001
6700
910
.... and so on ...

Instead of
910
1001
6700
.... and so on ...

Is this the normal behaviour ?
I thought a PK should be ordered (since there is an index on it)...

Thanks,
Steve


.

Relevant Pages

  • Re: SQL not working in 10g Release 2
    ... > The "SQL query" I am having is quite similar to the one I have ... > What was and is happening in Oracle 10g R1 is that, when I execute this ... Regards ... The Co-operative Oracle Users' FAQ ...
    (comp.databases.oracle.server)
  • Re: Is Linq worth it?
    ... myEvenList which in turn caused the query to immediately execute and store ... If you think of it as just a SQL query (but ... I'm a lot more excited about what I can use Linq for than I ... Things like anonymous types and type ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL Updates
    ... into separate commands and execute them. ... I have sql updates that I need to apply to the new version of my ... I can run this file on sql query analyzer to apply all the updates at ... either my file can have 'go's or semicolon. ...
    (microsoft.public.dotnet.languages.csharp)
  • DBI::execute(): how to evade quoting identifier names
    ... I try to execute the following SQL query in PostGreSQL 8.1. ... it gives errors since DBI::executeautomatically quotes when it inserts its arguments into the SQL query. ... # execute SQL statement with user-defined column name added ... PostGreSQL gives an error, since it only accepts unquoted identifiers. ...
    (perl.beginners)
  • SQL problem with SWI-Prolog
    ... execute an SQL query with a WHERE clause. ... I managed to execute simple SQL ... queries but my precidates always fail when i specify a WHERE clause. ... odbc_prepare(ccc, 'SELECT name, postcode FROM credit_history where ID ...
    (comp.lang.prolog)