–输出参数
create proc sp_output
@qian int,
@recordcount int output
as
begin
select * from DepartMent where qian>@qian
set @recordcount=(select COUNT(*) from DepartMent where qian>@qian)
end
–调用存储过程
–调用带有输出参数的存储过程的时候,需要定义变量,将变量传递给输出参数,在存储过程中使用的输出参数,其实就是你传递出来的变量
declare @rc int
exec sp_output 300,@recordcount=@rc output
print @rc--输出2