title: Passing Optional parameters while calling SQL SERVER's stored procedure in pymssql
body: <p>I am using pymssql library to retrieve data from MS SQL Server using stored procedures. 
  While passing Mandatory parameters, i have no issues. </p>
  
  <p>How to pass optional parameters in pymssql ? </p>
  
  <p>My stored proc has 5 parameters, 2 are mandatory and 3 are optional. </p>
  
  <pre><code>procedure_connection.cursor.callproc('PROCEDURE_NAME', (mandatory_parameter_1,mandatory_parameter_2))   
  </code></pre>
  
  <p>In what order I have to pass optional parameters ?</p>
  
  <pre><code>procedure_connection.cursor.callproc('PROCEDURE_NAME', (mandatory_parameter_1,mandatory_parameter_2,optional_parameter_1))   
  
  procedure_connection.cursor.callproc('PROCEDURE_NAME', (mandatory_parameter_1,mandatory_parameter_2,optional_parameter_2))   
  
  procedure_connection.cursor.callproc('PROCEDURE_NAME', (mandatory_parameter_1,mandatory_parameter_2,optional_parameter_3))   
  
  procedure_connection.cursor.callproc('PROCEDURE_NAME', (mandatory_parameter_1,mandatory_parameter_2,optional_parameter_1,optional_parameter_2,optional_parameter_3,))
  
  procedure_connection.cursor.callproc('PROCEDURE_NAME', (mandatory_parameter_1,mandatory_parameter_2))   
  </code></pre>
  
  <p>I want to pass optional parameters, and ensure that the right parameter is set instead of something.</p>