通过使用sqlCE上的参数减去值来更新行 [英] Update row by substracting values using parameters on sqlCE

问题描述

您好：



我正在尝试使用sqlCE提出查询。我有一个列数量，我想在用户输入金额时从列中减去。这就是我所拥有的：

Hello:

I am trying to come up with a query using sqlCE. I have a column "Qty" and I want to substract from the column as the user enters an amount. Here is what I have:

UPDATE       ItemInventoryControl
SET                Stocks = SUM(Stocks - @Stocks)
WHERE        (ItemName = @ItemName)

但是无法正常工作，我收到错误：

But is not working, I get an error:

SQL Execution Error

...Error Source: SQL Server Compact ADO.NET Data Provider 
Error Message: Not Implemented

推荐答案

尝试：

Try:

UPDATE       ItemInventoryControl
SET                Stocks = Stocks - @Stocks
WHERE        (ItemName = @ItemName)

如果要使用 UPDATE + SELECT 语句更新表，请尝试以下方法：

If you want to update table using UPDATE + SELECT statements, try this:

UPDATE dst SET Stock = src.Stock - dst.Stock
FROM ItemInventoryControl AS dst INNER JOIN  ItemInventoryControl AS src ON dst.PKey = src.PKey

这篇关于通过使用sqlCE上的参数减去值来更新行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！