create procedure select_procedure(@ID int,@num int output)
as
declare @n int
set @n = 0
select @n = count(*) from Employee where oid=@ID
set @num = @n
return @num
go
declare @value int
declare @res int
set @value = 1
execute select_procedure @value,@res output
print @res;