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

0 vote195 views1 answer
Cast as decimal postgresql
SQL
-2 votes224 views1 answer
How to open database
SQL
5 votes232 views3 answers
Db begintransaction laravel
SQL
0 vote197 views1 answer
Nth max in my sql
SQL
0 vote183 views1 answer
Dump only schema
SQL
0 vote196 views1 answer
Database xml sql
SQL
0 vote208 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote210 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote253 views1 answer
ALV GRID events
SQL
5 votes194 views1 answer
How to check nls timestamp format in oracle
SQL