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 vote178 views1 answer
Mysql convert charset
SQL
1 vote194 views2 answers
Get table column names sql laravel
SQL
1 vote188 views1 answer
Ef core 5.0 usesqlserver not found
SQL
0 vote194 views1 answer
Mssql dockere
SQL
1 vote208 views2 answers
Mysql extract number from string
SQL
6 votes292 views2 answers
Database url postgres
SQL
0 vote187 views1 answer
Psql get table data types
SQL
0 vote223 views1 answer
Sql multiple into
SQL
0 vote202 views2 answers
Collation in sql
SQL
0 vote199 views2 answers
Oracle create tablespace autoextend
SQL