cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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.
1 REPLY 1
Super User
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.