Return rows in the exact order they were inserted

by

A select query with no order by does not retrieve the rows in any particular order. You have to have an order by to get an order.

SQL Server does not have any default method for retrieving by insert order. You can do it, if you have the information in the row. The best way is a primary key identity column:

TableId int identity(1, 1) not null primary key

Such a column is incremented as each row is inserted.

You can also have a CreatedAt column:

CreatedAt datetime default getdate()

However, this could have duplicates for simultaneous inserts.

The key point, though, is that a select with no order by clause returns an unordered set of rows.

More Related Contents:

  1. SQL QUERY COUNT THEN ADD
  2. SQL server command help and tutorials for specific commands?
  3. Making a dynamic pivot table but without using the fiddle
  4. How do I UPDATE from a SELECT in SQL Server?
  5. How to return only the Date from a SQL Server DateTime datatype
  6. Referring to a Column Alias in a WHERE Clause
  7. Convert Datetime column from UTC to local time in select statement
  8. How to implement LIMIT with SQL Server? [duplicate]
  9. converting Epoch timestamp to sql server(human readable format)
  10. What are Covering Indexes and Covered Queries in SQL Server?
  11. How do I split a delimited string so I can access individual items?
  12. What’s the best way to select the minimum value from several columns?
  13. Add a summary row with totals
  14. Counting DISTINCT over multiple columns
  15. Why use Select Top 100 Percent?
  16. How to check if a stored procedure exists before creating it
  17. How do I find duplicates across multiple columns?
  18. Calculate business hours between two dates
  19. Correct use of transactions in SQL Server
  20. SSIS Source Format Implicit Conversion for Datetime
  21. store arabic in SQL database
  22. What is the Null Character literal in TSQL?
  23. how does SELECT TOP works when no order by is specified?
  24. SQL Server FOR XML Path make repeating nodes
  25. How do I change db schema to dbo
  26. Is there a severe performance hit for using Foreign Keys in SQL Server?
  27. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  28. Date serial in SQL?
  29. Parameterise table name in .NET/SQL?
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment