/*

DECLARE @OutPutValue VARCHAR(100)

EXEC spExample 'CodeProject', @OutPutValue OUTPUT

PRINT @OutPutValue

*/

CREATE PROCEDURE usp_Example

@parameter1 VARCHAR(100),

@parameter2 VARCHAR(200) OUTPUT

DECLARE @parameter3 VARCHAR(100)

SET @parameter3 = ' Your development resources.'

IF @parameter1 IS NOT NULL AND LEN(@parameter1) > 1

SELECT @parameter2 = 'The '

+ @parameter1

+ @parameter3

ELSE SELECT @parameter2 = 'Ramesh is cool!'

RETURN

END

GO

DECLARE @parameter2 AS VARCHAR(200)

EXEC usp_Example '', @parameter2 output

SELECT @parameter2 AS NAME

// It is hard to find the error in this code please help me with this code //