below is my stored procedure. what i want to do is to return the value 1 or 0 to an asp page. How can i pass the value 1 or 0 to an ASP page?
CREATE PROCEDURE DoesRecordExist
IF EXISTS(SELECT * FROM BasketItems WHERE ProductID = @pid)