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

-2 votes335 views1 answer
Create trigger syntax
SQL
0 vote341 views2 answers
Transaction php
SQL
10 votes322 views2 answers
Django mysql
SQL
0 vote365 views1 answer
Set default value now() date
SQL
0 vote370 views1 answer
Mysql multiple group by
SQL
4 votes341 views1 answer
Restart for pg_hba.conf file
SQL
0 vote404 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote352 views1 answer
Mariadb errno 121
SQL
0 vote344 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
4 votes362 views2 answers
Dbms output
SQL