Greg
Reputation: 47154
pyodbc on SQL Server - How can I do an insert and get the row ID back?
I'm using pyodbc with SQL Server 2000.
I want to be able to insert a row and get the auto incremented row id value back? Any ideas?
Here's what I have so far:
cursor.execute("insert into products(id, name) values ('pyodbc', 'awesome library')")
cnxn.commit()
Upvotes: 9
Views: 8506
Answers (1)
Greg
Reputation: 47154
Sorry, I asked too soon, it's addressed in their FAQ
Use "SELECT @@IDENTITY".
Upvotes: 10
Related Questions
- How to get the IDENTITY value when using INSERT ... OUTPUT with pyodbc
- Function sequence error in Python from pyodbc when getting id of row inserted into MSSQL
- Pyodbc: how can I get the primary key after a successful insert into the SQL Server database?
- Python Pyodbc cannot return first inserted id via executemany
- How to insert data into unique identifier column into SQL Server using pyodbc
- pyodbc insert into sql
- how to insert variable into database with pyodbc?
- Python DB API get inserted row id
- Returning primary key on INSERT with pyodbc
- Python Inserting data into Sql Server