title: pymssql can connect but does not return any results
body: <p>I am connecting to an MS SQL server with pymssql. I can connect by <code>tsql -H ip -p 1433 -U xx - p xx</code> and by jupyter notebook. The connection does not return any errors.</p>
  
  <p>However, I tried many queries with pymssql but none of them returned results.</p>
  
  <p>For example, <code>cursor.execute('SELECT * FROM INFORMATION_SCHEMA.TABLES ')</code></p>
  
  <p>What should I check now?</p>