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

4 votes211 views1 answer
Create column mysql terminal
SQL
0 vote198 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote229 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
8 votes208 views1 answer
Mac restore mysql database command line
SQL
6 votes232 views3 answers
How to delete table sqlite
SQL
0 vote238 views1 answer
One table with another
SQL
0 vote244 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote226 views1 answer
Mysql subdate
SQL
0 vote235 views1 answer
How to find sql server installation folder
SQL
9 votes234 views5 answers
Laravel to sql
SQL