import pyodbc

try:
    connection = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=.;DATABASE=SampleDB;Trusted_Connection=yes')

    cursor = connection.cursor()

    print("")
    print("select statement before insert")
    cursor.execute("select * from tblCustomers")

    while 1:
        row = cursor.fetchone()
        if not row:
            break
        print(row.id, row.code, row.firstName, row.lastName)

    prm_id = 7
    prm_code = "code7"
    prm_first_name = "firstName7"
    prm_last_name = "lastName7"
    print("inserting into tblCustomers...")
    cursor.execute("insert into tblCustomers values (?, ?, ?, ?)", prm_id, prm_code, prm_first_name, prm_last_name)
    connection.commit()

    print("select statement after insert")
    cursor.execute("select * from tblCustomers")

    while 1:
        row = cursor.fetchone()
        if not row:
            break
        print(row.id, row.code, row.firstName, row.lastName)

    cursor.close()
    connection.close()

except pyodbc.Error as ex:
    print()
    print("exception: ",ex)
    cursor.close()
    connection.close()
    print()
    exit()

print()