You can use LIMIT and OFFSET to write a SELECT statement that brings back rows referenced by "index" from the start of a table easily, but I'm looking for a way to insert/update rows by index rather ...
SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...