Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Into - doesnt insert in order?!?
Message
From
25/07/2001 17:21:52
Len Wooden
Statistical Resources, Inc
Baton Rouge, Louisiana, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Insert Into - doesnt insert in order?!?
Miscellaneous
Thread ID:
00535393
Message ID:
00535393
Views:
46
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
Next
Reply
Map
View

Click here to load this message in the networking platform