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

14 votes109 views1 answer
Excel
SQL
0 vote113 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote116 views1 answer
Convert polygon to text in mysql
SQL
0 vote117 views1 answer
How to get first 10 records of a table in mysql
SQL
1 vote97 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
1 vote100 views1 answer
Moodle query item quiz
SQL
4 votes110 views2 answers
Show all database inside postgresql
SQL
2 votes112 views3 answers
How to check current user in mySQL
SQL
0 vote120 views1 answer
How to install Firebird
SQL
0 vote120 views1 answer
SQL: calculate hours from two dates
SQL