General information
Forum:
Microsoft SQL Server
Title:
Insert Into - doesnt insert in order?!?
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only