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 votes407 views2 answers
Set value to null sql
SQL
0 vote325 views1 answer
Suse start MySQL
SQL
3 votes351 views1 answer
Dbms_scheduler drop_job
SQL
15 votes368 views7 answers
MYSQL
SQL
19 votes378 views6 answers
Mysql if null
SQL
0 vote339 views1 answer
Opensuse start MySQL
SQL
7 votes405 views1 answer
Buy forge mods server hosting
SQL
0 vote337 views1 answer
Postgresql create user roles
SQL
9 votes361 views1 answer
Mysql check date range
SQL
3 votes362 views2 answers
Update Query in SQL Server
SQL