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 vote241 views1 answer
How to to get time in sql
SQL
0 vote244 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote289 views1 answer
Postgres docs /copy metacomand
SQL
1 vote256 views2 answers
Mysql switch case
SQL
0 vote241 views1 answer
How to fetch unique records from two tables
SQL
8 votes242 views3 answers
Alter user root mysql
SQL
1 vote246 views1 answer
Drop column if exists sql server
SQL
0 vote233 views1 answer
Set column width in sqlplus
SQL
0 vote245 views1 answer
Sql select upcoming birthdays
SQL
0 vote288 views2 answers
Fanyi
SQL