This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 56.00000000000001%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEO%3C/text%3E%3C/svg%3E)
Hello
I have an SQL query in stored procedure to update an Amount balance column, my query is working fine, but the issue I am having is, sometimes when user updates I find out that the value doubled.
For example, where a user have 15, and update with another 15, instead of having 30, it will turn out to be 45. This usually happens when user clicked the submit button multiple times.
I really want to prevent that from happening.
Below is my query sample
Update AccTab
set AmtBal += @Amount
where UId = @UId;
if @@rowcount = 0 throw 50000, 'Hey, no rows were updated',1;
How do I position my query to make sure it updates with one increment in single update request.
Additional SQL Server features and topics not covered by specific categories
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
A set of technologies in .NET for building web applications and web services. Miscellaneous topics that do not fit into specific categories.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Hi @Emeka Okoye,
May I know if you have got any chance to check my reply? Please feel free to share more detailed information to us and it will be very helpful for us to better work out this issue.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
This is about the practice of making api calls idempotent. This is a main feature of correctly coded REST apis. This means the api detects the duplicate transaction and ignores it. This allow the client to safely reexecute the api call on network errors. The easiest way to implement is to add request ids for all api calls.
Hi @Emeka Okoye,
You can create a popup message box called "yes/no" to prevent multiple submit buttons.
Demo
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<script type = "text/javascript">
function confirm_closing() {
var confirm_closingValue = document.createElement("INPUT");
confirm_closingValue.name = "confirm_closingValue";
if (confirm("Do you want to accept the closing?")) {
confirm_closingValue.value = "CONFIRM";
} else {
confirm_closingValue.value = "CANCEL";
}
document.forms[0].appendChild(confirm_closingValue);
}
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:Button ID="btnConfirm" runat="server" OnClick="OnConfirm" Text="Confirm" OnClientClick="confirm_closing()"/>
</form>
</body>
</html>
public void OnConfirm(object sender, EventArgs e)
{
string confirmValue = Request.Form["confirm_closingValue"];
if (confirmValue == "CONFIRM")
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You clicked CONFIRM!')", true);
}
else
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('You clicked CANCEL!')", true);
}
}
Or design an UPDATE with a SELECT (untested):
Update AccTab
set AmtBal += @Amount
where UId = @UId
and not exists (select * from AccTab where AmtBal = (@Amount * 2));
Best regards,
Lan Huang
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread
This usually happens when user clicked the submit button multiple times.
Then it's a bug in your front end/business logic, nothing on SQL Server side.
Why don't you disable the button right after the user click it. If this does not satisfy your requirement, please let me know why.