I want to get a return value from a stored procedure, but it's not working at all. When I print out the value in ASP, it's empty.
oCmd.Parameters.Append(oCmd.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue, 4))
errCode = oCmd.Parameters("RETURN_VALUE")
SQL Stored Procedure:
declare @exists int
if exists (Select 1 From cases Where streetnum=@streetnum and streetname=@streetname and roads=@roads)
select @exists = 55555
Please help. Thanks.