stored procedure

alter procedure Maali

@Id int,

@empid varchar(max) output,

--@result varchar(max),

@IID int output

as 

Declare 

@name varchar(10),

@result varchar(max)

select @name=Name, @empid=EmployeeId ,@IID= Id from Employee where Id=@Id

exec Maalijod @empid,@IID,@result Output

print @result

print @empid 

print @IID  

alter procedure Maalijod

@empid int ,

 @IID int,

 @result varchar(max) OUtput

as declare 

@Place varchar(max)

select @Place=Place from Departement where ID=@IID

--set @result= @empid + @Place //can not concatenate integer and varchar therefore type casing is required. 

set @result= convert (varchar(10),@empid) + @Place //can also use cast keyword