SQL存储过程未声明变量是怎么回事?
来源:百度知道 编辑:UC知道 时间:2024/06/07 22:30:30
CREATE PROCEDURE ccc
(
@a money output
@b money output
)
AS
set nocount ON
select @a=Stock_min_money,@b=Stock_max_money from Stock where stock_id=3
set nocount OFF
GO
SQL提示我@b未声明变量.可是@b和@a已经做为输出函数声明变量了啊..请问这是怎么回事???
(
@a money output
@b money output
)
AS
set nocount ON
select @a=Stock_min_money,@b=Stock_max_money from Stock where stock_id=3
set nocount OFF
GO
SQL提示我@b未声明变量.可是@b和@a已经做为输出函数声明变量了啊..请问这是怎么回事???
CREATE PROCEDURE ccc
(
@a money output,--少了逗号
@b money output
)
AS
set nocount ON
select @a=Stock_min_money,@b=Stock_max_money from Stock where stock_id=3
set nocount OFF
少了逗号啦
@a money output,
@b money output
呵呵,楼上兄弟已经回答了,漏了逗号。