Execute sql-server transaction using python

Question

How can I execute sql server transaction using pyodbc(python)?

I know there is a method "execute" for one string and one arguments' list.

But now I want to execute 2 or more commands in one transaction like this.

Is there a method to do that?

BEGIN TRANSACTION [Tran1]

BEGIN TRY

INSERT INTO [Test].[dbo].[T1]
  ([Title], [AVG])
VALUES ('Tidd130', 130), ('Tidd230', 230)

UPDATE [Test].[dbo].[T1]
  SET [Title] = N'az2' ,[AVG] = 1
WHERE [dbo].[T1].[Title] = N'az'


COMMIT TRANSACTION [Tran1]

END TRY
BEGIN CATCH
  ROLLBACK TRANSACTION [Tran1]
END CATCH  

GO

Pavel Ryvintsev · Accepted Answer · 2016-04-11 09:23:45Z

10

When you create a connection object, you can tell it not to commit every command you execute. Then, when you have executed all the commands you wanted, you can commit them all in one transaction.

myconnection = pyodbc.connect(myconnectionstring, autocommit=False)
# your commands here
myconnection.commit()

answered Apr 11, 2016 at 9:23

Pavel Ryvintsev

1,0081 gold badge9 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Source Matters Over a year ago

would the "commands" be just individual .execute() statements with each different SQL statement?

Prashant Sharma Over a year ago

yes @SourceMatters

Collectives™ on Stack Overflow

Execute sql-server transaction using python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related