import pyodbc
#Conex SQL Server
server='NOTE_CLB\SQL_2019'
database = 'pmw'
username = 'sa'
password = 'admin123'
cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
cursor = cnxn.cursor()
#select query
cursor.execute("SELECT top 5 * from [CADASTROS_] ;")
row = cursor.fetchone()
while row:
print(row[0],'|',row[1],'|',row[2],'|',row[3],'|',row[5])
row = cursor.fetchone()