I have a SQL Server 2016 table with an order/position column. This column is an INT that indicates the preferred order/position of the rows in table for presentation purposes.
How do I INSERT a row in position 1 without using a cursor? (i.e. new row has position 1, existing rows - assumed to be in correct order before insert - must be "moved down")
The order/position column is NOT NULL and enforced to be UNIQUE. I would also prefer not to use "blunt force" technique like set all rows' order/position value to some "never used" values and then just perform reorder on all rows.