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

10 votes224 views1 answer
Oracle all_dependencies
SQL
4 votes285 views4 answers
Check constraint in ms sql
SQL
3 votes235 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote232 views1 answer
Db format in quotation
SQL
0 vote228 views1 answer
How to get data between a last week in mysql
SQL
0 vote217 views1 answer
Sql server select top 2 of each group
SQL
0 vote219 views1 answer
Sql count total by foreign key
SQL
-1 vote221 views2 answers
How to select the lowest values from table per client sql
SQL
-2 votes227 views2 answers
Sqlserver docker
SQL
0 vote244 views1 answer
How to move a columns location in mysql
SQL