title: Pymssql: Calling Stored Procedure with parameters
body: <p>I am using <a href="http://pymssql.sourceforge.net/" rel="nofollow noreferrer">pymssql</a> to make database calls to a SQL 2005 database. I want to pass parameters to a stored procedure. I am having a hard time getting the correct syntax for that. Here is what I have for calling a procedure with no parameters:</p>
  
  <pre><code>import _mssql
  connection = _mssql.connect(server='myserver', database='mydatabase', trusted=True)
  connection.execute_query('storedProcedureName')
  </code></pre>
  
  <p>Suppose I wanted to set the @Id parameter to 1. How would I do that? The following lines do not work. The docs are unclear as to how the params are structured.</p>
  
  <pre><code>connection.execute_query('storedProcedureName', {'@Id':'1'})
  connection.execute_query('storedProcedureName', '@Id=1')
  connection.execute_query('storedProcedureName', ('@Id', '1'))
  </code></pre>