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 vote170 views1 answer
Mysql check table exists
SQL
0 vote191 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote183 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote165 views1 answer
Restore backupfile discourse
SQL
0 vote185 views1 answer
Mysql milliseconds
SQL
1 vote175 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
1 vote212 views1 answer
Oracle drop temporary table
SQL
0 vote136 views1 answer
Check id exist or not in sql
SQL
0 vote191 views2 answers
Connect to mysql server mac terminal
SQL
0 vote161 views1 answer
Narural join
SQL