title: MSSQL2014 & python 3.7.3: Trying to get stored procedure return value results in "No results. Previous SQL was not a query."
body: <p>I'm running a python script which connects to a MSSQL database, runs a stored procedure and should take a some actions depending on the stored procedure return value. Here's the code:</p>
  
  <pre><code>'''
  sql = """\
          SET NOCOUNT ON
          DECLARE @rv INT
          EXEC @rv = [MY_DB].[dbo].[sp_Load_Actuals]
          SELECT @rv 
          """
  ...
  conn = pyodbc.connect('Driver={ODBC Driver 13 for SQL Server};'
                                        'Server=MY_SERVER;'
                                        'Database=MY_DB;'
                                        'Trusted_Connection=yes;')
  
  conn.autocommit = True
  cursor = conn.cursor()
  cursor.execute(sql)
  retv = cursor.fetchone() 
  ...
  </code></pre>
  
  <p>On the execution of the last statement I'm catching the <strong>pyodbc.DatabaseError</strong> exception with the message  <strong><em>"No results. Previous SQL was not a query."</em></strong> I have read all related articles here, but apparently I'm still doing something wrong. </p>
  
  <p>What do I miss?</p>