Stored Procedures in sqlserver

CREATE PROC usp_encryption
WITH ENCRIPTION
AS
BEGIN
SELECT * FROM emp
END

CREATE PROC usp_EvenOdd @i int
AS
BEGIN
IF @i%2=0
BEGIN
PRINT cast(i as varchar)+’is even number’
END
ELSE
PRINT cast(i as varchar)+’is odd number’
END


CREATE PROC usp_addition @i int,@j int
AS
BEGIN
DECLARE @res int
SET @res=@i+@j
PRINT  ‘The Addition is ‘+CAST(@res AS VARCHAR)
END

EXEC usp_addition 20,30

CREATE PROC usp_outputtest @sal money,@updatesal money output
AS
BEGIN
SET @updatesal=@sal+1500
END
CREATE PROC usp_updatesal @eno int
AS
BEGIN
DECLARE @sal money,@updatedsal money
SELECT @sal=sal FROM emp WHERE eno=@eno
EXEC usp_outputtest @sal,@updatesal output
UPDATE emp SET sal=@updatedsal WHERE eno=@eno
END

EXEC usp_updatesal 1