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 vote342 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
12 votes323 views4 answers
Mysql version query
SQL
0 vote357 views1 answer
Check if string is a number sql
SQL
2 votes336 views1 answer
Sql ends with string
SQL
3 votes320 views1 answer
Oracle function
SQL
0 vote318 views1 answer
Like and not like together in sql
SQL
0 vote348 views1 answer
Show the colums of table sql
SQL
0 vote323 views1 answer
PSQL qith variables
SQL
2 votes332 views1 answer
How to show the whole table in sql
SQL
1 vote326 views1 answer
Oracle sql create view
SQL