是否有一种方法可以使用pyodbc向sql server 2005插入一个请求scope_identity()

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 osI have this great pyodbc lib. I try the code be