Question

Connect and execute Microsoft SQL on Python Shutdown Script

  • 27 June 2018
  • 1 reply
  • 6 views
B
Badge +1

Has anyone successfully executed an insert\\delete SQL statement to a SQL database via Python in the Shutdown Script?

1 reply

david_r
Rank
Userlevel 4

Have a look at using the pyodbc module, see also this discussion on StackOverflow: https://stackoverflow.com/a/33787509

The SQL Server writers also have a parameter you can set, containing a SQL command to execute at the end:

Reply


Community Stats

28,723
Posts
109,511
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.