How to read from a table in MSSQL with Python

I use this code

import pyodbc

conn = pyodbc.connect('driver={ODBC Driver 17 for SQL Server};'                                           'server=XXXXXXXXXXXX;'                                            'database=YYYYYYYYYYY;'                                            'uid=ZZZZZZZZZZZ;'                                            'pwd=QQQQQQQQQQ;')

rs = conn.cursor()


rs.execute('SELECT top 10 *  FROM quant_test with (NOLOCK)')
for row in rs:
    print(row)

Comments

Post a Comment

Popular posts from this blog

Installing Microsoft ODBC Driver to connect to SQL from Python on Mac OS X

What a nightmare it's been for me to figure this out. Remember to have homebrew installed in advance. Then run this in terminal: brew install msodbcsql At first, it didn't work for me, saying something about taps was empty and no available formulas. Then I found out I needed to run this command in Terminal rm -rf /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core; brew update Then I could run brew install msodbcsql ... but not successfully. OK, so I tried another approach /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"  brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update  brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release followed by...   brew install msodbcsql17 mssql-tools This seems to have worked! My driver is now  ODBC Driver 17 for SQL Server Ressources: https://do...
Read more

Connection to MSSQL with Pythonan and pyodbc (on Mac OS X)

There are many python SQL drivers available. Microsoft however places its efforts and confidence in pyodbc driver. If the library pyodbc is not installed, do the following Open Terminal Run this command: pip3 install pyodbc The following will be the result brians-air:~ imac$ pip3 install pyodbc Collecting pyodbc   Downloading https://files.pythonhosted.org/packages/92/91/c0c473491b49a5492f911b745d1388da9c60dd152a93841dc90cf21d0e97/pyodbc-4.0.27-cp37-cp37m-macosx_10_9_x86_64.whl (63kB)     100% |████████████████████████████████| 71kB 237kB/s   Installing collected packages: pyodbc Successfully installed pyodbc-4.0.27 You are using pip version 19.0.3, however version 19.2.3 is available. You should consider upgrading via the 'pip install --upgrade pip' command. It's now installed. But does it work? No... Not at first! At least not for me. That didn't work for me and when trying to import the library, this was the result. Input: im...
Read more

Installing PyCharm on Mac

I use PyCharm to edit, run and debug my Python code. It does not exist in the App Store. Instead, get it from  https://www.jetbrains.com/pycharm/ Get the community edition for learning. The installation is about 340 mb. Once it's installed go ahead and launch the application. Before you go ahead and create a new project, change the Python Interpreter from Virtualenv Environment to System Interpreter and select the latest version of Python (in my case it's Python3 that we have just installed) Tip: Skip to about 8 minutes in to this video for more info:  https://www.youtube.com/watch?v=oyzH4M6X6F4
Read more