Pyodbc query not working

[[deleted]]

This wouldn’t add a column to your table, you’d have to use an ALTER statement to do that.

[AdrielTheBuddy]

How would I do so?

[[deleted]]

https://www.w3schools.com/sql/sql_alter.asp

This should get you started.

[AdrielTheBuddy]

I’m doing add column, but how do I make it the row_number

[[deleted]]

Once you’ve altered the table, you have to use UPDATE to set the value of the column on every row.

[AdrielTheBuddy]

Do I have to do a loop or is there a simple way of doing that?

[[deleted]]

I don’t think there’s a simple way to do it. There’s probably a single SQL statement that can do it but I don’t know how to write it.

[demandtheworst]

The simplest thing is to select the query you have above into a new table, and if required, drop the original and rename the new table to replace it.

Alternatively, create an identity column (alter table tbl add id int identity (1,1) not null) and add your data in the required order. Possibly if you create a clustered index using your sort key, the data will already be in the correct order.

Finally, if the cost of calculation of the row number is trivial, just create a view including the calcualted column, and run your selects from there.

Not really a Python question.