Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymssql
- import pandas as pd
- conn = pymssql.connect(server = r"DELLG3SQLEXPRESS", database = "MyDB", user="sa", password="******")
- Q = pd.read_sql_query("select * from Scripts", conn)
- df = pd.DataFrame(Q, columns=['Script'])
- df.head()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement