SQL查询存储过程错误的帮助. [英] SQL Query Stored Procedure Wrong Help.
本文介绍了SQL查询存储过程错误的帮助.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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屋!
查看全文