SQL查询存储过程错误的帮助. [英] SQL Query Stored Procedure Wrong Help.

问题描述

CREATE PROCEDURE Transfer
@orderValue int,
@custFName nvarchar(20),
@custLName nvarchar(20)
AS
UPDATE [Money]
FROM CustomerBankInfo
INNER JOIN Customer
ON CustomerBankInfo.CustomerID = Customer.CustomerID
SET [Money] = [Money] - @orderValue;
WHERE Customer.FirstName = @custFName AND Customer.LastName = @custLName

附近语法错误=" ="

"INCORRECT SYNTAX NEAR ''=''"

SET [Money] = [Money] - @orderValue;

我究竟做错了什么?有人可以帮帮我吗.

What am I doing wrong? Could someone help me out please.

推荐答案

您不能在update语句中加入两个表.您可以改用子查询.尝试ff.代码:

You cannot join two tables in update statement. You can use subqueries instead. Try the ff. codes:

UPDATE CustomerBankInfo
SET Money = (money - @ordervalue)
WHERE CustomerBankInfo.CustomerID = (SELECT CustomerID
                                     FROM Customer
                                     WHERE Firstname = @custFName
                                     AND LastName = @custName)

这篇关于SQL查询存储过程错误的帮助.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！