title: is there a way to do a insert an request the scope_identity() using pyodbc to sql server 2005
body: <p>I have this great pyodbc lib. I try the code below, it supposed to insert a row and return the row id but it didn't work. by the way I'm using sql server 2005 on server and client is windows os</p>
  
  <pre><code>...
  con = pyodbc.connect('conectionString', autocommit = True)
  cur = con.execute(
                    "insert into sometable values('something');
                    select scope_identity() as id"
                    )
  for id in cur:
     print id
  ...
  </code></pre>
  
  <p>some idea?</p>