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 vote106 views1 answer
IIF
SQL
3 votes111 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote104 views1 answer
Heavy table in mysql
SQL
0 vote121 views1 answer
Sql tablo sp
SQL
6 votes119 views2 answers
Sql display max value
SQL
4 votes115 views2 answers
Tsql utf to local time
SQL
0 vote137 views2 answers
How to truncate all table in mysql workbench
SQL
37 votes187 views6 answers
Mysql update
SQL
0 vote116 views1 answer
Cannot start database server xampp mac os
SQL
5 votes114 views1 answer
Oracle scan source ddl
SQL