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 vote123 views1 answer
How to display value of variable in mysql
SQL
8 votes119 views6 answers
Sql insert
SQL
5 votes110 views2 answers
Postgres update with if condition query
SQL
9 votes118 views4 answers
How to create new user and database postgresql in ubuntu
SQL
4 votes119 views1 answer
Wildcard in sql
SQL
0 vote120 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote119 views1 answer
T-sql check if data exists
SQL
0 vote127 views1 answer
Oracle execute immediate quotes
SQL
1 vote160 views1 answer
Psql client write to bash variable
SQL
7 votes114 views6 answers
Group_concat mysql
SQL