Problem with stored procedure

Question

Hi friends I am getting an errorcan someone plzz point out where i am going wrong: Must declare the scalar variable @UserID. Stored procedure is: CREATE PROCEDURE dbo.spRetrieveBalance AS SELECT Balance from Account WHERE UserID=@UserID Thank you

Rajesh Kumar · Answer

Hi suchitra Modify your's given statement like this: CREATE PROCEDURE [dbo].[spRetrieveBalance ] @UserID int AS Begin

Satish Bhat · Answer

Santhosh N is correct. but also declare the correct data type for the parameter @UserID. e.g. CREATE PROCEDURE dbo.spRetrieveBalance @UserID int / varchar(20) / ... AS SELECT Balance from Account WHERE UserID=@UserID

Suthish Nair · Answer

Suchitra Mark the reply that helped you as accepted answer.

Santhosh N · Answer

Your stored procedure does not have an input parameter of userid declared and hence this error write something like this.. CREATE PROCEDURE dbo.spRetrieveBalance @UserID AS SELECT Balance from Account WHERE UserID=@UserID

B M Suchitra · Answer

Thanks to all the people who replied to my post.. The problem is solved.