SQL: Return "true" if list of records exists?
Posted
by User
on Stack Overflow
See other posts from Stack Overflow
or by User
Published on 2010-05-19T00:23:07Z
Indexed on
2010/05/19
0:30 UTC
Read the original article
Hit count: 607
An alternative title might be: Check for existence of multiple rows?
Using a combination of SQL and C# I want a method to return true if all products in a list exist in a table. If it can be done in all in SQL that would be preferable. I have written a method that returns whether a single productID exists using the following SQL:
SELECT productID FROM Products WHERE ProductID = @productID
If this returns a row, then the c# method returns true, false otherwise.
Now I'm wondering if I have a list of product IDs (not a huge list mind you, normally under 20). How can I write a query that will return a row if all the product id's exist and no row if one or more product id's does not exist?
(Maybe something involving "IN" like:
SELECT * FROM Products WHERE ProductID IN (1, 10, 100))
© Stack Overflow or respective owner