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 vote186 views1 answer
Start stop mysql linux
SQL
1 vote149 views2 answers
Sql groub by count
SQL
0 vote168 views1 answer
View to table
SQL
0 vote147 views1 answer
Data structures in sql
SQL
2 votes157 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote167 views1 answer
Postgresql inline table
SQL
3 votes145 views2 answers
Oracle grants
SQL
0 vote149 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
-1 vote169 views1 answer
Capitole toulouse
SQL
0 vote146 views1 answer
Greater than or equal to symbol in postgres
SQL