谁能给写一个简单的一个输入参数,一个输出参数,和一个返回值的存储过程,并怎么去调用它?

在线等待,马上结帐!
---------------------------------------------------------------

create procedure yourP
@inp int ,@outp int output
as
set @outp=@inp+100
return @inp

-------
declare @tt int,@oo int
exec @tt=yourP 1,@oo output

print @tt
print @oo

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus