pip install pymssql
python
import pymssql
cursor = conn.cursor()
result = cursor.fetchall()
for row in result:
print(row)
conn.close()
python
import pymssql
cursor = conn.cursor()
data = [
('value1', 'value2'),
('value3', 'value4'),
]
cursor.executemany(insert_sql, data)
conn.commit()
conn.close()
python
import pymssql
import pandas as pd
df = pd.read_sql(query, conn)
conn.close()
