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

-1 vote326 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote280 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote294 views1 answer
Sqlalchemy get schema from database
SQL
2 votes326 views2 answers
Create temporary table in mysql
SQL
1 vote248 views1 answer
Mysql get last insert id
SQL
0 vote290 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
11 votes275 views1 answer
How to get ddl for materialized view
SQL
0 vote309 views1 answer
Sqlite insert or update
SQL
0 vote273 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
3 votes302 views5 answers
Foreign keys
SQL