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

3 votes217 views3 answers
Mysql declare variable
SQL
0 vote274 views1 answer
ORA-01400
SQL
26 votes196 views2 answers
What is the sql statement that finds duplicate usernames
SQL
3 votes193 views1 answer
Delete all content in table mysql
SQL
0 vote218 views4 answers
Mysql desactivar trigger
SQL
18 votes210 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote194 views1 answer
Mariadb LOAD DATA INFILE
SQL
7 votes248 views1 answer
Show line number in sql server
SQL
0 vote222 views4 answers
User defined function sql
SQL
0 vote234 views1 answer
How to insert multiple values in a single column in sql
SQL