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 vote309 views1 answer
Psql check table fields
SQL
0 vote291 views2 answers
Oracle ora-00054 how to unlock
SQL
5 votes299 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote281 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote282 views1 answer
How to read the potentail error messages in ssis package
SQL
3 votes293 views3 answers
Stop mysql ubuntu
SQL
0 vote281 views2 answers
Auto increment column in mysql query results
SQL
0 vote260 views1 answer
Backup a table in sql
SQL
0 vote278 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote275 views1 answer
Mysql find db contarint
SQL