mssql_script25.py
570 Bytes
import pyodbc
hil_sql = """
ALTER TABLE hil_auto_settlement ADD is_fsm tinyint not null default 0;
"""
afc_sql = """
ALTER TABLE afc_auto_settlement ADD is_fsm tinyint not null default 0;
"""
hil_cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};', autocommit=True)
hil_cursor = hil_cnxn.cursor()
hil_cursor.execute(hil_sql)
hil_cursor.close()
hil_cnxn.close()
afc_cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};', autocommit=True)
afc_cursor = afc_cnxn.cursor()
afc_cursor.execute(afc_sql)
afc_cursor.close()
afc_cnxn.close()