connect to ssms with python code example
Example: 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)