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

16 votes223 views6 answers
Mysql find duplicates in same table
SQL
0 vote178 views1 answer
Oracle enable chain
SQL
0 vote194 views1 answer
Edit shchima table in sql
SQL
0 vote158 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote162 views1 answer
Mysql jdbc timezone
SQL
0 vote174 views1 answer
Date on SQL
SQL
19 votes171 views6 answers
What is mySQL
SQL
0 vote177 views1 answer
Add SuperUser MySQL
SQL
5 votes193 views1 answer
Oracle add time to date
SQL
0 vote173 views1 answer
Cast float mysql
SQL