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

1 vote261 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote297 views2 answers
T sql null or empty string
SQL
0 vote231 views1 answer
Check sql query executed wp
SQL
0 vote279 views1 answer
Sql order by except one row
SQL
1 vote255 views1 answer
How to select department from table
SQL
2 votes270 views1 answer
Oracle list grants on package
SQL
0 vote262 views1 answer
Groupby error in mysql
SQL
0 vote275 views1 answer
Insert set mysql
SQL
4 votes261 views1 answer
Create table if not exist in sqlite
SQL
0 vote299 views1 answer
Check constraint is violated
SQL