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 vote276 views1 answer
Oracle grant select on schema
SQL
4 votes205 views1 answer
Oracle delete last row
SQL
24 votes210 views4 answers
Postgres remove database
SQL
0 vote205 views1 answer
Find invalid datetime field
SQL
0 vote205 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
2 votes185 views2 answers
How to get capital letter first in sql
SQL
1 vote217 views1 answer
Isnull sql server
SQL
0 vote204 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote287 views1 answer
Mysql extract day from date leading zero
SQL
0 vote253 views1 answer
Mysql show foreign keys column
SQL