定义如下存储过程： create procedure mytest ( @returnval decimal output --定义一个输出变量 ) as declare @amount decimal declare mycursor cursor for select amount from dbo.test --定义一个游标 open mycursor fetch next from mycursor into @amou
定义如下存储过程：
create procedure mytest
(
@returnval decimal output --定义一个输出变量
)
as
declare @amount decimal
declare mycursor cursor for select amount from dbo.test --定义一个游标
open mycursor
fetch next from mycursor into @amount
while @@fetch_status=0
begin
 if(@amount=100)begin
  set @returnval = @amount
 end
 fetch next from mycursor into @amount
end
close mycursor
deallocate mycursor
return 1;
go
执行存储过程获取返回值和输出值：
declare @output decimal
declare @val int
exec @val=mytest @returnval = @output output
select @val,@output
，网站空间，香港空间，香港空间