Skip to content

Instantly share code, notes, and snippets.

@hunterowens

hunterowens/pymssql.py

Created October 22, 2015 18:56
Show Gist options
  • Save hunterowens/b3e2f6d24e9260c33262 to your computer and use it in GitHub Desktop.
Save hunterowens/b3e2f6d24e9260c33262 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pymssql.py
import pymssql
conn = pymssql.connect(server="", user="",password="", port=)
stmt = "SELECT * FROM AlumniMirror..vwApp_Detail WHERE applied_dummy = 1;"
df = pd.read_sql(stmt,conn)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment