Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. import pymssql
  2. import pandas as pd
  3.  
  4. conn = pymssql.connect(server = r"DELLG3SQLEXPRESS", database = "MyDB", user="sa", password="******")
  5. Q = pd.read_sql_query("select * from Scripts", conn)
  6. df = pd.DataFrame(Q, columns=['Script'])
  7.  
  8. df.head()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement