procedure

SQL SERVER 2005

select * from spt_values where name is not null 

create procedure pro_test
  as 
 select * from spt_values where name is not null
 go 

execute  pro_test


--intput paramater
alter proc  pro_test
 @num int
as 
select * from spt_values where name is not null and number=@num
go

execute pro_test @num=1

--output paramater

alter proc pro_test
 @result int output
 as 
select @result=count(*) from spt_values  where name is not null
go 

declare @result2 int
execute pro_test @result=@result2 output
print @result2

 2.oracle