原来的存贮过程定义如下:create procedure writescore
@score int,
@code varchar(20),
@flag int output
as
IF((select TestScore from StudentInfo where StudentID=@code)>0)
begin
update StudentInfo set TestScore=@score where StudentID=@code
set @flag = 1
end
ELSE
set @flag = 0
想执行下,请教下?exec writescore '20','123456789',@flag执行不行
主要是输出参数怎么给?
@score int,
@code varchar(20),
@flag int output
as
IF((select TestScore from StudentInfo where StudentID=@code)>0)
begin
update StudentInfo set TestScore=@score where StudentID=@code
set @flag = 1
end
ELSE
set @flag = 0
想执行下,请教下?exec writescore '20','123456789',@flag执行不行
主要是输出参数怎么给?
declare @flag intexec writescore '20','123456789',@flag output
输出参数必须要用OUTPUT 标记。