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 vote379 views1 answer
Wordpress change http to https phpmyadmin
SQL
0 vote369 views1 answer
Mariadb alter table add column if not exists example
SQL
2 votes344 views1 answer
How to add where command in update comand with joins
SQL
0 vote383 views1 answer
Sql date time query find
SQL
0 vote344 views1 answer
Sql examples from your work
SQL
2 votes329 views2 answers
Insert all in sql
SQL
4 votes358 views2 answers
What is table in sql
SQL
4 votes370 views4 answers
Rollback in sql
SQL
0 vote355 views1 answer
Mysql workbench view
SQL
22 votes348 views4 answers
Show list of users in mysql
SQL