How can I create new records and dicatate into which row number they are inserted?
by Patrick
Q: My table which PK column cotains 20 rows, row 9 was deleted, now I want a new record to be inserted in row 9 and not 21 – how can I do this?
Patrick O’Keeffe says: New rows are always inserted at the end of the table, unless the table has a clustered index in which case the position depends on the index value.
There is no concept of a “row number” in SQL Server, sorry!
Share this post with friends
