必须声明标量变量“@ E_NAME”。 [英] Must declare the scalar variable "@E_NAME".

问题描述

我创建一个存储过程但是在插入时会声明标量变量会有问题。

如何解决它请帮助我。



我使用以下代码：

I Create a Stored Procedure But in Insert there will be problem in declare the scalar variable.
How to solve it Please help me.

I use the Following code:

CREATE PROCEDURE SP_EVALUETOR
(
	@E_NAME VARCHAR(50),
	@QULL VARCHAR(50),
	@LANG_KNOW VARCHAR(50),
	@GENDER VARCHAR(50),
	@OCCU VARCHAR(50),
	@PWD VARCHAR(50),
	@E_LANG VARCHAR(50)
)
AS
BEGIN

INSERT INTO Evaluator (UserName, Qualification, LanguageKnow, Gender, Occupation, PWD, Evaluetor_Language)
VALUES(@E_NAME,@QULL,@LANG_KNOW,@GENDER,@OCCU,@PWD,@E_LANG)


END

SELECT * FROM Evaluator

推荐答案

从参数部分删除（）并重试。

Remove the () from the parameter section and try again.

CREATE PROCEDURE SP_EVALUETOR
@E_NAME VARCHAR(50),
@QULL VARCHAR(50),
@LANG_KNOW VARCHAR(50),
@GENDER VARCHAR(50),
@OCCU VARCHAR(50),
@PWD VARCHAR(50),
@E_LANG VARCHAR(50)
AS
BEGIN
INSERT INTO Evaluator (UserName, Qualification, LanguageKnow, Gender, Occupation, PWD, Evaluetor_Language)
VALUES(@E_NAME,@QULL,@LANG_KNOW,@GENDER,@OCCU,@PWD,@E_LANG)
END

SELECT * FROM Evaluator

你应该像我一样修改你的SP以下示例（不使用参数声明中的括号）：

You should modify your SP like in the example bellow (without using brackets in the param declaration):

CREATE PROCEDURE SP_EVALUETOR
--( -- Without using brackets!
@E_NAME VARCHAR(50),
@QULL VARCHAR(50),
@LANG_KNOW VARCHAR(50),
@GENDER VARCHAR(50),
@OCCU VARCHAR(50),
@PWD VARCHAR(50),
@E_LANG VARCHAR(50)
--) --Without using brackets!
AS
BEGIN
INSERT INTO Evaluator (UserName, Qualification, LanguageKnow, Gender, Occupation, PWD, Evaluetor_Language)
VALUES(@E_NAME,@QULL,@LANG_KNOW,@GENDER,@OCCU,@PWD,@E_LANG); --Must add ";" at the end!
-- END -- END must be at the end of the SP!
SELECT * FROM Evaluator;
END

这篇关于必须声明标量变量“@ E_NAME”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！