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 vote139 views1 answer
Firebird where
SQL
1 vote132 views1 answer
Oracle get current schema
SQL
0 vote149 views1 answer
Sql cmd no truncate
SQL
4 votes140 views2 answers
Oracle sql group by date year
SQL
0 vote198 views1 answer
Mysql update table from select on another table
SQL
1 vote135 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
7 votes135 views3 answers
Sql fill table with info from anothe rtable
SQL
1 vote131 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
8 votes126 views1 answer
Unique vs primary key
SQL
0 vote193 views1 answer
Get last inserted primary key
SQL