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

24 votes265 views4 answers
Postgres delete database
SQL
0 vote217 views1 answer
Lister les index d'une table oracle
SQL
0 vote259 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote222 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote255 views1 answer
Plpgsql raise notice
SQL
1 vote235 views1 answer
Oracle extract minute from date
SQL
0 vote230 views2 answers
What is 1=2 in sql
SQL
0 vote242 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote229 views1 answer
Sqlite3 update select
SQL
19 votes219 views6 answers
Laravel sql query
SQL