pip install pymssql
python
import pymssql
server = 'server_name'
user = 'username'
password = 'password'
database = 'database_name'
conn = pymssql.connect(server=server, user=user, password=password, database=database)
python
try:
conn = pymssql.connect(server=server, user=user, password=password, database=database)
except pymssql.MSSQLDatabaseException as e:
python
try:
cursor = conn.cursor()
cursor.execute("SELECT * FROM employees")
rows = cursor.fetchall()
for row in rows:
print(row)
except pymssql.MSSQLQueryException as e:
python
conn = pymssql.connect(server=server, user=user, password=password, database=database, as_dict=True)
