[RESOLVED] Execution of SP in SQL Server 2008

[sonia.sardana]

Mine SP : -

CREATE PROCEDURE [dbo].[GetMarks]
@iRoll int,
@iMarks int OUTPUT
AS
BEGIN
Select @iMarks = marks  from student where roll = @iRoll 
END
GO

In this SP,for consideration I just use the simple Table STudent whose columns are Roll & Marks.
Through SP, I want to get the Marks as OutPut Parameter by Passing ROll as Input Parameter. My SP is succeed successfully.

I just want to know how to Execute it & see the Result of SP in SQL .
To Execute I use the following commands : -

Declare @temp_Marks Int 
EXEC GetMarks 1 , @iMarks = @temp_Marks

When I execute the above statement I get the message Command(s) completed successfully.But I am not able to see the Mark of Roll Number 1. How to get that?? Kindly Help ME!!!!