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 vote307 views1 answer
Create table sql generator
SQL
0 vote326 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
3 votes296 views2 answers
Mysql HAVING
SQL
0 vote321 views1 answer
Insert or update sql query
SQL
10 votes263 views1 answer
Oracle view dependencies
SQL
0 vote295 views1 answer
How to query all tables mysql at the same time
SQL
0 vote345 views1 answer
How to get button for every record from mysql
SQL
0 vote303 views1 answer
Which lock mode is not available in sql
SQL
0 vote308 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote330 views1 answer
Oracle table privileges
SQL