CREATE PROCEDURE test @job_id int,@desc char(20) output
AS
select @desc=job_desc from jobs where job_id = @job_id
GO