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

1 vote323 views1 answer
Psql connect to another database
SQL
0 vote338 views1 answer
How to select even id in sql
SQL
0 vote334 views1 answer
Mysql insert into select with recursive
SQL
1 vote374 views1 answer
Sql row having max
SQL
0 vote383 views1 answer
Traccar mysql
SQL
6 votes353 views1 answer
Oracle rank
SQL
0 vote332 views1 answer
Sauvegarde complète my sql
SQL
0 vote336 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote394 views1 answer
Find and replace query in wordpress\
SQL
0 vote366 views1 answer
Get clob size oracle
SQL