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 vote370 views1 answer
Space not removing from column in sql
SQL
0 vote315 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote335 views1 answer
Mysql c commands
SQL
0 vote356 views1 answer
Login failed for user sql server
SQL
0 vote326 views1 answer
How to display value of variable in mysql
SQL
0 vote333 views1 answer
Make a socket server to detect changes in mysql
SQL
1 vote350 views1 answer
Mysql datetime with timezone offset
SQL
1 vote326 views1 answer
SQL server query column yes or no
SQL
10 votes364 views2 answers
Tsql merge example
SQL
3 votes478 views9 answers
Linq to sql converter online
SQL