Connect to ssms with python

import pyodbc 
conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=server_name;'
                      'Database=database_name;'
                      'Trusted_Connection=yes;')

cursor = conn.cursor()
cursor.execute('SELECT * FROM database_name.table')

for row in cursor:
    print(row)

Source: datatofish.com

Similar codes

6 votes191 views2 answers
Difference between join vs union
SQL
28 votes262 views6 answers
Foreign key
SQL
0 vote198 views1 answer
Oracle decode
SQL
0 vote191 views1 answer
USING THE NOT CONDITION IN SQL
SQL
2 votes213 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
1 vote168 views1 answer
Oracle finding duplicate records
SQL
1 vote189 views3 answers
How to pass password to mysql command line
SQL
0 vote190 views1 answer
Python connect to mysql in settings.py
SQL
0 vote181 views1 answer
Drop database using terminal postgres
SQL
3 votes177 views5 answers
Sql select
SQL