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 vote346 views1 answer
Sql server whoami
SQL
1 vote358 views1 answer
How to check the mysql version mac
SQL
1 vote437 views1 answer
Sql select row with max date
SQL
0 vote367 views1 answer
EnvironmentError: mysql_config not found
SQL
9 votes407 views3 answers
Import DB through mysql console
SQL
1 vote364 views1 answer
Error code 1175 mysql fix
SQL
15 votes408 views4 answers
Create table if not exists sql
SQL
0 vote352 views1 answer
Php get closest location by latitude longitude
SQL
1 vote384 views3 answers
Postgresql get difference between two dates
SQL
3 votes335 views4 answers
Show sql server database
SQL