Inserting Through Pymssql But No Rows Appear In The Database

Im quite new to python and im trying to write a script that puts values into a SQL database. its a simple 2 column table that looks like this: CREATE TABLE [dbo].[pythonInsertTest

Solution 1:

Ha, I've banged my head on this a few times as well. As far as I can tell, you are missing a commit statement. As per this example, add a conn.commit(), and hopefully you will be golden.