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

11 votes110 views2 answers
Insert current date sql
SQL
16 votes117 views3 answers
Order by sql query
SQL
0 vote111 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote108 views1 answer
Set a value by excuting stored procedure
SQL
5 votes69 views1 answer
Alter table default value mysql
SQL
5 votes106 views1 answer
Ascending order and where in sql
SQL
0 vote106 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote169 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote108 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote96 views1 answer
Calculate date and convert to yearsmysql
SQL