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 vote218 views1 answer
Download mysql database to excel in android studio
SQL
3 votes223 views1 answer
Force using index oracle
SQL
0 vote232 views1 answer
What is top n result in sql
SQL
0 vote225 views1 answer
Sql server udf performance
SQL
0 vote221 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
2 votes209 views1 answer
Drop table if exists in postgres
SQL
36 votes226 views3 answers
Finding duplicate column values in table with sql
SQL
14 votes223 views2 answers
Sql cast
SQL
0 vote228 views7 answers
Les jointures sql server
SQL
0 vote282 views1 answer
What is metadata in sql
SQL