pip install pymssql
python
import pymssql
python
server = 'localhost'
username = 'username'
password = 'password'
database = 'sample_database'
python
conn = pymssql.connect(server, username, password, database)
python
query = 'SELECT * FROM table_name'
cursor = conn.cursor()
cursor.execute(query)
python
result = cursor.fetchall()
python
cursor.close()
conn.close()
