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

3 votes136 views1 answer
Oracle undo tablespace schema
SQL
1 vote121 views1 answer
Deleting database in sql
SQL
0 vote255 views2 answers
Mysql insert rows to another database
SQL
0 vote86 views1 answer
Mysql select top 2
SQL
0 vote130 views1 answer
Get initial in sql
SQL
4 votes156 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote121 views1 answer
Last 6 months postgresql
SQL
0 vote125 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote159 views1 answer
Mysl like insert a variable
SQL
3 votes134 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL