title: How to get the IDENTITY value when using INSERT ... OUTPUT with pyodbc
body: <p>I am trying to get the ID of a newly inserted row by using <code>OUTPUT</code>. However, I encountered the HY010 error. The following query/code is what I use:</p>
  
  <pre><code>string = """
           SET NOCOUNT ON;
           DECLARE @NEWID TABLE(ID INT);
  
           INSERT INTO dbo.t1 (Username, Age)
           OUTPUT inserted.id INTO @NEWID(ID)
           VALUES(?, ?)
  
           SELECT ID FROM @NEWID
           """
  
  cursor.execute(string, "John Doe", 35)
  cursor.commit()
  id = cursor.fetchone()[0]
  </code></pre>
  
  <p>the last line <code>id = cursor.fetchone()[0]</code> led to a HY010 error (see below). Any advice would be greatly appreciated!</p>
  
  <pre><code>pyodbc.Error: ('HY010', '[HY010] [Microsoft][ODBC SQL Server Driver]Function sequence error (0) (SQLFetch)')
  </code></pre>