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 vote136 views1 answer
Oracle array
SQL
26 votes140 views2 answers
Mysql workbench download
SQL
12 votes132 views2 answers
Insert multiple rows from another table sql
SQL
1 vote129 views1 answer
Postgresql convert text to float
SQL
0 vote143 views1 answer
Sqlalchemy get schema from database
SQL
0 vote139 views1 answer
How to close external sql connection in laravel
SQL
0 vote127 views1 answer
Soql more than today
SQL
0 vote139 views1 answer
Alter table add check constraint oracle
SQL
0 vote128 views1 answer
Postgresql where clause not working
SQL
0 vote85 views1 answer
Ms sql print more than 1 variable
SQL