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