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 vote257 views1 answer
SQLite order random
SQL
0 vote253 views1 answer
Oracle DROP PROGRAM
SQL
1 vote238 views1 answer
GROUP BY clause; this is incompati
SQL
7 votes265 views2 answers
What is sql clause
SQL
0 vote226 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote261 views2 answers
PostgreSQL having
SQL
4 votes287 views1 answer
Sql select limit range
SQL
1 vote263 views1 answer
Sqlite update from another table
SQL
0 vote262 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote246 views1 answer
Uuid sqlalcomany
SQL