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 vote258 views1 answer
How to select only id where is not in column mysql
SQL
0 vote260 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote265 views1 answer
Mysql workbench view
SQL
0 vote251 views1 answer
Acual month sql
SQL
0 vote270 views1 answer
Convert LDAP Epoch to Date
SQL
2 votes270 views2 answers
Install postgresql
SQL
8 votes263 views2 answers
Safe update mode in mysql
SQL
0 vote213 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
4 votes245 views1 answer
Sql data types
SQL
0 vote276 views1 answer
Get clob size oracle
SQL