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 vote290 views1 answer
Having all mysql
SQL
2 votes283 views1 answer
Merge firstname and lastname in sql oracle
SQL
-1 vote253 views3 answers
Check table exist postgresql
SQL
16 votes248 views3 answers
Order by sql query
SQL
2 votes256 views1 answer
Mariadb select multiple rows into one column
SQL
2 votes279 views1 answer
Sql OR
SQL
2 votes265 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
12 votes271 views4 answers
Mysql get date difference in hours
SQL
1 vote235 views1 answer
Stored procedure return value
SQL
3 votes267 views1 answer
Select sequence oracle
SQL