lundi 5 janvier 2015

Need to find Error in the following code. Following code gives everything in the output irrelevant of the input values


ALTER PROCEDURE Search (@city VARCHAR(15),
@srch VARCHAR(15),
@date DATE,
@zip INT)
AS
SELECT *
FROM Supplier
WHERE ( city = @city
AND ( CompanyName = @srch
OR CompAdd = @srch
OR status = @srch
OR zip = @zip
OR DOJ = @date ) )

Aucun commentaire:

Enregistrer un commentaire