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 vote282 views1 answer
Copy Table from SQL to CSV
SQL
0 vote270 views1 answer
How to install mysql without admin rights
SQL
0 vote306 views1 answer
Oracle show grants on table
SQL
0 vote275 views1 answer
Drop all tables db2
SQL
0 vote306 views1 answer
Create table like sql
SQL
0 vote267 views1 answer
Mysql xampp reset root password
SQL
0 vote259 views2 answers
Avg() sql
SQL
0 vote312 views1 answer
Distance calculator from lat long sql query
SQL
0 vote309 views1 answer
Psql check table fields
SQL
0 vote278 views1 answer
Sql create text column limited values
SQL