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 vote295 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote285 views1 answer
Hibernate with springboot mysql
SQL
0 vote288 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote313 views1 answer
How to make case insensitive in sql
SQL
0 vote288 views1 answer
Mysql update from n to 100
SQL
5 votes292 views2 answers
Oracle rename table
SQL
0 vote308 views1 answer
Mysql extract day from date leading zero
SQL
10 votes276 views1 answer
Dba_dependencies
SQL
4 votes300 views2 answers
Show all database inside postgresql
SQL
4 votes313 views1 answer
Conda install sqlalchemy
SQL