Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert Into - doesnt insert in order?!?
Message
De
25/07/2001 17:21:52
Len Wooden
Statistical Resources, Inc
Baton Rouge, Louisiane, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Insert Into - doesnt insert in order?!?
Divers
Thread ID:
00535393
Message ID:
00535393
Vues:
45
Currently writing a routine that batch inserts records from VFP to SQL using a stored procedure and the INSERT INTO command. I was shocked to see that the SELECT statement (after running the inserts) returned a cursor with the records in no particular order.. if the SQL table is cleared and then the inserts are run again.. the records are again in a different order.. none of which match the original VFP physical order. Any suggestions? Is the idea of 'physical order' dead once you move to SQL and you have to rely on identifiers, orders, and/or indices? Thanks in advance -- Len
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform