mgF2N6Cc

1SELECT productID FROM Products WHERE ProductID = @productID
2	
3(Maybe something involving "IN" like:
4SELECT * FROM Products WHERE ProductID IN ('1', '10', '100', 'ABC'))
5	
6SELECT COUNT(*) FROM Products WHERE ProductID IN (1, 10, 100)
7	
8SELECT COUNT(DISTINCT ProductID) FROM Products WHERE ProductID IN (1, 10, 100)
9	
10SELECT ProductId FROM Products WHERE ProductID IN (1, 10, 100) AND ((SELECT COUNT(*) FROM Products WHERE ProductID IN (1, 10, 100))=3)
11	
12SELECT ProductId FROM Products WHERE ProductID IN (1, 10, 100) AND ((SELECT COUNT(DISTINCT ProductID) FROM Products WHERE ProductID IN (1, 10, 100))=3)
13	
14create table products
15(
16product_id int not null
17);
18
19
20
21insert into products values(1),(2),(10),(100);
22
23SELECT 
24    CASE 
25        WHEN EXISTS(
26             SELECT 1 
27             FROM (values(1),(10),(100)) as x(id) 
28             WHERE x.id NOT IN (select product_id from products))
29        THEN 0 --'NOT ALL'
30
31        ELSE 1 -- 'ALL'
32    END
33	
34create table product_memory(product_id int) engine=MEMORY;
35
36insert into product_memory values(1),(10),(100);
37
38SELECT 
39    CASE 
40        WHEN EXISTS(
41             SELECT 1 
42             FROM product_memory
43             WHERE product_memory.id NOT IN (select product_id from products))
44        THEN 0 -- 'NOT ALL'
45
46        ELSE 1 -- 'ALL'
47    END
48	
49bool isAllExist = (int)(new SqlCommand(queryHere).ExecuteScalar()) == 1;
50	
51SELECT 1
52WHERE 
53    NOT EXISTS(
54        SELECT 1
55             FROM product_memory
56             WHERE product_memory.id NOT IN (select product_id from products) )
57	
58SELECT 1
59WHERE 
60    NOT EXISTS(            
61        SELECT 1 
62        FROM (values(1),(10),(100)) as x(id) 
63        WHERE x.id NOT IN (select product_id from products) )
64	
65var da = new SqlDataAdapter(queryhere, connectionhere);
66var dt = new DataTable();
67da.Fill(dt);
68
69if (dt.Rows.Count > 0) 
70    return true; 
71else 
72    return false;
73	
74return dt.Rows.Count > 0;
75	
76SELECT
77      CASE WHEN EXISTS 
78      (
79            SELECT * FROM table WHERE 1
80      )
81      THEN 'TRUE'
82      ELSE 'FALSE'
83   END
84	
85DECLARE @values TABLE (ProductId int)
86INSERT @values (1)
87INSERT @values (10)
88INSERT @values (100)
89
90SELECT CASE WHEN (SELECT COUNT(*) FROM @values v) = 
91                 (SELECT COUNT(*) FROM Products p WHERE p.ProductId IN
92                       (SELECT v.ProductId FROM @values v))
93            THEN CAST(1 AS bit)
94            ELSE CAST(0 AS bit)
95       END [AreAllFound]
96	
97// not familiar with C#, but C#'s equivalent of PHP's:
98$count = count($productIds); // where $productIds is the array you also use in IN (...)
99
100SELECT IF ((SELECT COUNT(*) FROM Products WHERE ProductID IN (1, 10, 100)) = $count, 1, 0)
101	
102SELECT (SELECT COUNT(1)
103          FROM product_a
104         WHERE product_id IN (1, 8, 100)
105       ) = (number of commas in product_id as constant)
106	
107SELECT (SELECT COUNT(*)
108          FROM product_a
109         WHERE product_id IN (SELECT Products
110                                FROM #WorkTable)
111       ) = (SELECT COUNT(*)
112              FROM #WorkTable)
113	
114select "all exist"
115where (select case  when count(distinct t.id) = (select count(distinct id) from #products) then "true" else "false" end
116    from ProductTable t, #products p
117    where t.id = p.id) = "true"
118	
119SELECT "All Exist"
120WHERE(
121        SELECT case when count(distinct t.id) = @ProductCount then "true" else "false" 
122        FROM ProductTable t 
123        WHERE t.id in (1,100,10,20) -- example IDs
124) = "true"
125	
126CREATE PROCEDURE usp_CheckAll 
127    (@param dbo.ProductTableType READONLY)
128AS
129BEGIN
130    SELECT CAST(1 AS bit) AS Result
131    WHERE (SELECT COUNT(DISTINCT ProductID) FROM @param)
132        = (SELECT COUNT(DISTINCT p.ProductID) FROM @param AS p
133           INNER JOIN Products 
134               ON p.ProductID = Products.ProductID)
135END
136	
137CREATE PROCEDURE usp_CheckAll 
138    (@param dbo.ProductTableType READONLY)
139AS
140BEGIN
141    SELECT CAST(1 AS bit) AS Result
142    WHERE NOT EXISTS (
143        SELECT * FROM @param AS p
144        LEFT JOIN Products 
145            ON p.ProductID = Products.ProductID
146        WHERE Products.ProductID IS NULL
147    )
148END
149	
150select (select count(*) from players where productid in (1, 10, 100, 1000)) = 4
151	
152String.Join(",", input.Split(",").Select(s => Int32.Parse(s).ToString()))
153	
154declare @are_equal bit
155declare @products int
156
157SELECT @products = 
158     count(pl.id)
159FROM ProductList pl
160JOIN Products p
161ON pl.productId = p.productId
162
163select @are_equal = @products == select count(id) from ProductList
164	
165var compareProducts = new List<Product>(){p1,p2,p3,p4,p5};
166var found = From p in GetAllProducts()
167            Join cp in compareProducts on cp.Id equals p.Id
168            select p;
169
170return compareProducts.Count == found.Count;
171	
172SELECT CAST(COUNT(ProductID) AS bit) AS [EXISTS] FROM Products WHERE(ProductID = @ProductID)
173	
174select 1
175    from Products
176    where ProductId IN (1, 10, 100)
177	
178select case when EXISTS (
179    select 1
180        from Products
181        where ProductId IN (1, 10, 100)
182    ) then 1 else 0 end as [ProductExists]
183	
184SELECT COUNT(*)>0 FROM `table` WHERE condition;