gajayku (7/9/2014)
HiMy unique Id is of type string. Is that is the problem for random data insertion??
I think you used a SELECT statement to verify the results?
Tables in a relational model do not have any order.
I repeat: do not have any order.
If you want an order, use ORDER BY in your query.
The database does not care if the unique ID jumps from 520 to 6000.
It is even possible the actual storage of the data is in another order. Who knows? The order of rows retrieved depends on so many things, such as indexes and query plan.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP