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

0 vote184 views4 answers
Sql year
SQL
0 vote190 views1 answer
Print boolean in plsql
SQL
0 vote215 views1 answer
Mysql add text to existing field
SQL
49 votes315 views6 answers
Install mysql ubuntu
SQL
0 vote225 views1 answer
Stop and start mysql
SQL
0 vote219 views1 answer
Sql alter table order by
SQL
7 votes217 views1 answer
Mysql unsafe update
SQL
0 vote186 views1 answer
Select last N rows mysql
SQL
16 votes239 views3 answers
Order by sql query
SQL
0 vote176 views1 answer
Mariadb LOAD DATA INFILE
SQL