sql - Insert between two rows?

Question

I wish to know how I can insert a row between the two rows of a table. I am using MS-SQL and SQL management studio.

Any help will be much appreciated.

Answer 1

If you do just a

SELECT (columns) FROM dbo.MyTable

there is no guaranteed order in the output - it might look like it's ordered, but there's no guarantee for anything.

If you want to order by something, you need to explicitly specify that by adding an ORDER BY clause to your statement:

SELECT (cols) FROM dbo.MyTable ORDER BY FirstName

Therefore, you cannot "insert" a new row between two other rows - it will just show up wherever it belongs, based on the order you've defined