Passing multiple NULL and Value to Where clause in SQL Server

Last Reply 11 months ago By dharmendr

Posted 11 months ago


i have this below query i want to apply filters on 

categoryid, brandid, productid, subcateogryid

select categoryid, brandid, productid, subcategory From Product

all are integes if any filter is not pass all data should come

if categoryid is pass so all data matching categoryid should come if categoryid and brandid is passed so all data matching cateogryid and brandid should come and go on

storeprocedure would work pls advice

This question does not have replies that have been liked.