cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vsslasd
Level: Powered On

Is there a way to wrap patch statements in a begin/end transaction

Is there a way to wrap patch statements in a begin/end transaction, like in SQL Server Begin/End transaction? 

 

Thank you!


Accepted Solutions
Super User Rank
Super User

Re: Is there a way to wrap patch statements in a begin/end transaction

There's no way to wrap patch statements in a begin/end transaction. One workaround is to encapsulate your logic inside a SQL stored procedure. Within your stored procedure, you can begin your transaction and update/insert your records. You'd then call your stored procedure from Flow.

All Replies
Super User Rank
Super User

Re: Is there a way to wrap patch statements in a begin/end transaction

There's no way to wrap patch statements in a begin/end transaction. One workaround is to encapsulate your logic inside a SQL stored procedure. Within your stored procedure, you can begin your transaction and update/insert your records. You'd then call your stored procedure from Flow.