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 vote144 views1 answer
Apt install sql server
SQL
-1 vote194 views1 answer
Minus vs except in sql
SQL
13 votes138 views2 answers
Sqlite rename column
SQL
7 votes150 views1 answer
Query delete duplicates
SQL
1 vote137 views2 answers
Find a column in all tables mysql
SQL
0 vote149 views2 answers
SQL FROM
SQL
2 votes131 views2 answers
Compare date mysql
SQL
0 vote137 views1 answer
RowDataPacket
SQL
8 votes155 views1 answer
Show mysql user table
SQL
0 vote133 views1 answer
Resulting Query
SQL