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

0 vote189 views4 answers
Forenkey code alchemy sql
SQL
6 votes187 views3 answers
Mysql server is not starting xampp
SQL
0 vote209 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote221 views2 answers
Temp tables in sql server
SQL
9 votes190 views3 answers
Where in sql
SQL
0 vote201 views1 answer
Synapse sql table set pk
SQL
11 votes201 views2 answers
Having in sql
SQL
5 votes191 views1 answer
Mysql created at yesterdau
SQL
0 vote194 views1 answer
How to put is null in where in clause
SQL
2 votes232 views1 answer
Mysql select true or false
SQL