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

10 votes303 views4 answers
Primary key sql
SQL
8 votes283 views2 answers
Alter column name in mssql
SQL
9 votes310 views3 answers
Oracle undo usage by session
SQL
0 vote290 views1 answer
Oracle sql date summer time
SQL
10 votes374 views6 answers
Mysql set root password
SQL
0 vote311 views1 answer
Call procedure in wordpress
SQL
1 vote334 views1 answer
Oracle enable job
SQL
0 vote310 views2 answers
How to update the multiple rows in sql
SQL
0 vote333 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote321 views1 answer
Where field is null sql knex
SQL