B M Suchitra

B M Suchitra

  • 1.6k
  • 507
  • 402.5k

Problem with stored procedure

Dec 21 2010 3:04 AM
Hi friends,
I am getting an error,can 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



Answers (5)