Requirement :
When a Product ID or multiple Product IDs is/are passed, all the information of the Product (Product Name, Price, Quantities Available, Description, etc) should be fetched for the passed Product ID/Product IDs.
When Product ID is not passed (null), then Product Information of all the available Product IDs should be fetched.
In my application, Product_Id is a List<string>. I'm passing this list to my SQL Select query as a parameter. If this list is null I have to select all the Product IDs from Product table. If its not null, then I have to fetch only those Product IDs that are in the list.
The query I'm trying to write for the above requirement is given below. Please can anybody help me to do this?
SELECT * FROM PRODUCT WHERE PRODUCT_ID IN (?)
