title: Python - pyodbc call stored procedure with parameter name
body: <p>I need to call a <code>SqlServer stored procedure</code> from <code>python2.7</code> via <code>pyodbc</code> module with input parameter name.</p>
  
  <p>I tried based on <a href="https://code.google.com/p/pyodbc/wiki/Cursor" rel="noreferrer">documentation</a> by input parameter order:</p>
  
  <pre><code>cursor.execute('{CALL [SP_NAME](?,?)}',
                ('value', 'value'))
  </code></pre>
  
  <p>It works, but I need to pass <code>parameter name of stored procedure</code> because order of stored procedure input parameter always changes. So I need to pass them by name.</p>
  
  <pre><code>cursor.execute('{CALL [SP_NAME](@param1name,@param2name)}',
                ('value', 'value'))
  </code></pre>
  
  <p>However this doesn't work. What's the correct syntax?</p>