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

16 votes301 views2 answers
Sql exists
SQL
5 votes306 views2 answers
Sql conn
SQL
0 vote294 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote296 views1 answer
Rabbitmq ui not working
SQL
0 vote323 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote339 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote325 views1 answer
Sql multiple into
SQL
0 vote295 views2 answers
How to know the character set of an oracle databes
SQL
1 vote294 views1 answer
Sql eliminare un record
SQL
20 votes282 views2 answers
Mysql bigint max value
SQL