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 vote160 views1 answer
ORA-01400
SQL
6 votes123 views4 answers
Mysql group by date
SQL
0 vote113 views1 answer
Delete first row in sql
SQL
1 vote124 views1 answer
Mysql is odd
SQL
0 vote135 views1 answer
Insert into table with only identity column
SQL
0 vote116 views1 answer
Sql on-premises
SQL
0 vote109 views1 answer
Low level operator in dbms
SQL
3 votes116 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
2 votes115 views1 answer
Guid to string sql
SQL
3 votes129 views2 answers
Oracle drop sequence
SQL