call procedure from another proc

create table emp (eno int,ename varchar(10),salary int)

insert into emp values (1,'sekar',10000)

insert into emp values (15,'mothi',15000)

insert into emp values (19,'sarav',18000)

insert into emp values (12,'visu',19000)

insert into emp values (11,'nosh',16000)

go

select * from emp

select * from emp where ename='sekar'

declare @ename varchar(10)

drop proc pemp1

create proc pemp

@ename varchar(10)

as

begin

select salary from emp where ename=@ename

end

exec pemp 'sekar'

---------------------------------------

---------------------------------------

create table emp (eno int,ename varchar(10),salary int)

insert into emp values (1,'sekar',10000)

insert into emp values (15,'mothi',15000)

insert into emp values (19,'sarav',18000)

insert into emp values (12,'visu',19000)

insert into emp values (11,'nosh',16000)

go

----------------------

alter proc pemp

@ename varchar(10) ,

@salary int out

as

begin

select @salary = salary from emp where ename=@ename

end

-------------------------

alter proc pemp1

@salary int

as

begin

declare @sal int

exec pemp 'mothi' , @sal out

select ename from emp where salary =@sal

end

exec pemp1 2000