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 vote265 views1 answer
Update sql join multiple tables
SQL
0 vote342 views1 answer
Updating database in sql
SQL
1 vote311 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
3 votes306 views1 answer
Oracle apex warning message
SQL
2 votes310 views1 answer
Plsql block
SQL
0 vote314 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
1 vote336 views1 answer
Sqlserver create table from select
SQL
5 votes318 views3 answers
Oracle first day of last year
SQL
0 vote312 views1 answer
Unique index in mysql
SQL
0 vote358 views1 answer
What logs are available on RDS MySQL?
SQL