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

20 votes180 views1 answer
Get all table name in sql through php
SQL
0 vote194 views1 answer
Oracle select partition
SQL
1 vote202 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
4 votes198 views2 answers
How to insert ip address in mysql using php
SQL
0 vote229 views2 answers
Sql update multiple tables
SQL
6 votes224 views2 answers
Mysql 1 day ago
SQL
1 vote211 views1 answer
Update from select join
SQL
5 votes193 views3 answers
Mysql extract month from date
SQL
0 vote192 views1 answer
Mysql coonect sample code
SQL
0 vote250 views1 answer
Start stop mysql linux
SQL