How to maintain the order of insertion in SQL Server

by

You are misguided.

SQL tables represent unordered sets. If you want a result set in a particular order, then you need to use an ORDER BY clause in the query. The SQL optimizer might not use the ORDER BY, finding another way to return the results in order.

You can have an identity column that is not the primary key. But actually, you can have both an identity column and a guid column, with the former as the primary key and the latter as a unique key. Another solution is to have a CreatedAt datetime. You can use this for ordering . . . or even as a clustered index if you really wanted to.

More Related Contents:

  1. How to make a query with group_concat in sql server [duplicate]
  2. Using merge..output to get mapping between source.id and target.id
  3. Column “invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause”
  4. Connection to SQL Server Works Sometimes
  5. How to change identity column values programmatically?
  6. SQL Server Regular expressions in T-SQL
  7. Combine two tables that have no common fields
  8. Is it possible to use Full Text Search (FTS) with LINQ?
  9. Need a datetime column in SQL Server that automatically updates when the record is modified
  10. SQL Server pivot vs. multiple join
  11. Real vs. Floating Point vs. Money
  12. how to make your data horizontal
  13. How do I find a stored procedure containing ?
  14. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  15. An attempt to login using SQL authentication failed
  16. Parse XML in SQL Server
  17. Calling stored procedure using VBA
  18. How to find SQL Server running port?
  19. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  20. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  21. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  22. Database design: Calculating the Account Balance
  23. Cannot bulk load. Operating system error code 5 (Access is denied.)
  24. INFORMATION_SCHEMA vs sysobjects
  25. Does query plan optimizer works well with joined/filtered table-valued functions?
  26. Get row where datetime column = today
  27. Full text catalog/index search for %book%
  28. Why insert-select to variable table from XML variable so slow?
  29. Slow query with cfqueryparam searching on indexed column containing hashes
  30. How to avoid SSIS FTP task from failing when there are no files to download?

Leave a Comment