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
Loading
Rajesh KumarPosted Dec 21, 2010, 3:59 AM
Modify your's given statement like this:
CREATE PROCEDURE [dbo].[spRetrieveBalance ]
@UserID int
AS
Begin
Suthish NairPosted Dec 22, 2010, 4:39 AM
Mark the reply that helped you as accepted answer.
B M SuchitraPosted Dec 21, 2010, 4:29 AM
Satish BhatPosted Dec 21, 2010, 3:55 AM
e.g.
CREATE PROCEDURE dbo.spRetrieveBalance
@UserID int / varchar(20) / ...
AS
SELECT Balance from Account WHERE UserID=@UserID
Santhosh NPosted Dec 21, 2010, 3:25 AM
write something like this..
CREATE PROCEDURE dbo.spRetrieveBalance @UserID
AS
SELECT Balance from Account WHERE
UserID=@UserID