python.sql.ipynb

python.sqldb.txt

#Libraries
import pyodbc

#Connection to SQL database

server = 'tcp:SQLSERVER.database.windows.net' 
database = 'DBNAME' 
username = 'user@contoso.com' 
password = 'password' 

connection = pyodbc.connect('Driver={ODBC Driver 18 for SQL Server};Server='+server+',1433;Database='+database+';Uid='+username+';Pwd='+password+';Encrypt=yes;TrustServerCertificate=no;Connection Timeout=180;Authentication=ActiveDirectoryInteractive')
cursor = connection.cursor()

#Sample select query
cursor.execute("SELECT @@version;")
row = cursor.fetchone()
while row:
    print(row[0])
    row = cursor.fetchone()