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

13 votes193 views2 answers
Get date from now() mysql
SQL
0 vote197 views1 answer
Sql server count all tables rows
SQL
3 votes207 views2 answers
Monthname sql
SQL
0 vote158 views1 answer
Mysql timeout 30 seconds
SQL
4 votes198 views1 answer
Postgresql list sequences
SQL
0 vote200 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote234 views1 answer
Mysql create index lost connection
SQL
1 vote192 views1 answer
How to use db.execute
SQL
1 vote199 views1 answer
Oracle avg
SQL
5 votes182 views3 answers
Mysql update field from one table to another
SQL