Sql server set variable if exists

-- set @my_var = @my_val IF ALL values in a specified col(s) of @table1
-- also exist in a specified col(s) of @table2
-- OTHERWISE, set @my_var = 0
SET @my_var = CASE
WHEN NOT EXISTS (
SELECT my_col FROM @table1
EXCEPT                
SELECT my_col FROM @table2
THEN @my_val
ELSE 0
END

Similar codes

3 votes396 views1 answer
Apex call duration
SQL
10 votes340 views2 answers
Select nextval from sequence oracle
SQL
0 vote320 views1 answer
Sql get month and year from date
SQL
0 vote397 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote329 views1 answer
Operator does not exist: integer = text
SQL
0 vote376 views1 answer
How to find unique element in sql
SQL
2 votes356 views3 answers
Mysql kill
SQL
0 vote321 views1 answer
Mysql count with two joins
SQL
11 votes359 views2 answers
Oracle source code
SQL
0 vote315 views1 answer
Mysql date time string format python
SQL