问题描述
我有这个存储过程:
ALTER PROCEDURE spCertificationType
@result nvarchar(15) output,
@mode int
AS
BEGIN
if @mode = 1
begin
exec spGeneratedID 2, @result output
print @result
end
END
但是当我尝试执行它时,它出现了这个错误
but when I tried to execute it,it has this error
形式参数@mode"没有声明为 OUTPUT 参数,而是在请求的输出中传递的实际参数.
The formal parameter "@mode" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.
我尝试将 @mode
设置为这样的输出:
I tried to set @mode
as output like this:
ALTER PROCEDURE spCertificationType
@result nvarchar(15) output,
@mode int output
AS
BEGIN
if @mode = 1
begin
exec spGeneratedID 2, @result output
print @result
end
END
但它返回一个空值.
有什么解决办法吗?提前致谢.
Any fix for this? Thanks in advance.
推荐答案
存储过程中参数的顺序是先使用输入参数再使用输出参数:-您可以查看此链接以获取有关存储过程的更多知识:-
the sequence of parameter in store procedure is that first use input parameter then use output parameter:- you can see this link for more knowledge of store procedure:-
http://www.codeproject/Articles/126898/Sql-Server-How-To-Write-a-Stored-Procedure-in-SQL
ALTER PROCEDURE spCertificationType
@mode int,
@result nvarchar(15) output
AS
BEGIN
if @mode = 1
begin
exec spGeneratedID 2, @result output
print @result
end
END
这篇关于形式参数“@mode"未声明为 OUTPUT 参数,而是在请求的输出中传递的实际参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
更多推荐
[db:关键词]
发布评论