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 vote133 views2 answers
Uninstall postgresql mac
SQL
2 votes134 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
3 votes127 views1 answer
Oracle drop user
SQL
0 vote119 views1 answer
Mysql function variable
SQL
15 votes129 views5 answers
Show tables in oracle
SQL
0 vote124 views1 answer
Sqlite referential integrity
SQL
24 votes125 views5 answers
Sql reset auto increment
SQL
0 vote125 views1 answer
Mariadb cast to int
SQL
1 vote129 views1 answer
Alter add syntax
SQL
0 vote143 views1 answer
Python connect to mysql in settings.py
SQL