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 vote179 views3 answers
How to run sql query
SQL
0 vote178 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote132 views2 answers
Postgresql could not start server mac
SQL
0 vote234 views1 answer
Sql delete caracter list
SQL
0 vote168 views1 answer
Sql server 2012 create or alter procedure
SQL
1 vote195 views4 answers
Aggregate function in sql
SQL
0 vote126 views1 answer
How to set field to null in sql
SQL
12 votes219 views6 answers
How to install sqlite3 in python
SQL
1 vote167 views1 answer
Oracle explain plan
SQL
3 votes170 views4 answers
Show sql server database
SQL