Hi,
I am creating a stored procedure which contains an output parameter.
Though the procedure is getting compiled properly I am not able to
execute it from within SQL Server Management Studio and also through
an aspx page. I keep getting empty output (not null)

The code:

Create procedure LoginUser

       @cust_Password varbinary,
       @cust_name varchar,
       @cust_id int output

AS

BEGIN

       SELECT  @cust_id=Id from Customer where Name=@cust_name and
Password=@cust_Password;

END

How can I retreive the value @cust_id ?