[RESOLVED] Execution of SP in SQL Server 2008

[sonia.sardana]

Hello ALL, I changed my SP as follows : -

Create PROCEDURE [GetMarks]  
@iRoll int,  
@iMarks int OUTPUT  ,
@sName varchar(10) OUTPUT
AS  
BEGIN  
 (select marks from student where roll = @iRoll)  END

Called in the SP in the following way : -

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

It Worked for me.
In the original SP, I just Changed the statement (BOLD) & all worked