Data is not guaranteed to be stored in any particular way. Order is only enforced when you query, and include an ORDER BY. It is often said that data in a clustered index is stored physically in order, but even that is an abstraction - the physical pages may not necessarily be contiguous or in order, but the pointers from page to page ensure that the clustered index structure is in order. Why do you ask? Are you expecting the data to come 'out' the same way it went 'in'?
Hi Key Riley Suppose there is a table called Transaction Transactionid Transactionname Date Amount Here Transactionid has alpha numeric data type. it dont have primary key value. Now we have insert 10000 Records My Question 1)Which column Way SQL Server Stored this Data like Transactionid or Transactionname? 2)How records Stored inside database engine like pages or which mechanism SQL is following?