If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
indexing in a table
Hi,
Can anyone confirm (or deny) that when indexing in a table is set to 'Yes - No Duplicates' and then you try and append data from a sorted query into that table, DOES THE TABLE ALWAYS ACCEPT THE FIRST ROW (as sorted by the query) or is it more random than that. thanks S |
#2
|
|||
|
|||
indexing in a table
On Sun, 28 Feb 2010 14:19:01 -0800, sdg8481
wrote: SQL is not random. In fact it is firmly rooted in mathematical set theory, and all its operations are 100% predictable. If you meant to ask "I have another table that has data that would violate the unique index; what happens when I append that data to this table with unique index?" I would expect that indeed the first rows would make it to the table. If you wanted to be sure, you would change your query to only select those "first" records. Techniques like "select * from Orders where OrderDate = (select Min(OrderDate) from Orders O2 where O2.CustomerID = Orders.CustomerID)" can be used. -Tom. Microsoft Access MVP Hi, Can anyone confirm (or deny) that when indexing in a table is set to 'Yes - No Duplicates' and then you try and append data from a sorted query into that table, DOES THE TABLE ALWAYS ACCEPT THE FIRST ROW (as sorted by the query) or is it more random than that. thanks S |
#3
|
|||
|
|||
indexing in a table
Thats what i thought and thats what i was hoping you would say..
Thank You "Tom van Stiphout" wrote: On Sun, 28 Feb 2010 14:19:01 -0800, sdg8481 wrote: SQL is not random. In fact it is firmly rooted in mathematical set theory, and all its operations are 100% predictable. If you meant to ask "I have another table that has data that would violate the unique index; what happens when I append that data to this table with unique index?" I would expect that indeed the first rows would make it to the table. If you wanted to be sure, you would change your query to only select those "first" records. Techniques like "select * from Orders where OrderDate = (select Min(OrderDate) from Orders O2 where O2.CustomerID = Orders.CustomerID)" can be used. -Tom. Microsoft Access MVP Hi, Can anyone confirm (or deny) that when indexing in a table is set to 'Yes - No Duplicates' and then you try and append data from a sorted query into that table, DOES THE TABLE ALWAYS ACCEPT THE FIRST ROW (as sorted by the query) or is it more random than that. thanks S . |
#4
|
|||
|
|||
indexing in a table
"sdg8481" wrote in message ... Thats what i thought and thats what i was hoping you would say.. Thank You "Tom van Stiphout" wrote: On Sun, 28 Feb 2010 14:19:01 -0800, sdg8481 wrote: SQL is not random. In fact it is firmly rooted in mathematical set theory, and all its operations are 100% predictable. If you meant to ask "I have another table that has data that would violate the unique index; what happens when I append that data to this table with unique index?" I would expect that indeed the first rows would make it to the table. If you wanted to be sure, you would change your query to only select those "first" records. Techniques like "select * from Orders where OrderDate = (select Min(OrderDate) from Orders O2 where O2.CustomerID = Orders.CustomerID)" can be used. -Tom. Microsoft Access MVP Hi, Can anyone confirm (or deny) that when indexing in a table is set to 'Yes - No Duplicates' and then you try and append data from a sorted query into that table, DOES THE TABLE ALWAYS ACCEPT THE FIRST ROW (as sorted by the query) or is it more random than that. thanks S . |
#5
|
|||
|
|||
indexing in a table
;,;,v,;
"sdg8481" a écrit dans le message de groupe de discussion : ... Hi, Can anyone confirm (or deny) that when indexing in a table is set to 'Yes - No Duplicates' and then you try and append data from a sorted query into that table, DOES THE TABLE ALWAYS ACCEPT THE FIRST ROW (as sorted by the query) or is it more random than that. thanks S |
Thread Tools | |
Display Modes | |
|
|