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

1 vote52 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote110 views1 answer
Laravel eloquent get generated sql
SQL
0 vote99 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote99 views1 answer
Oracle for loop on list
SQL
0 vote130 views1 answer
Oracle create package specification
SQL
36 votes121 views3 answers
Add column in mysq
SQL
0 vote103 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote103 views1 answer
Get rows affected mysql python
SQL
2 votes92 views1 answer
Sqlite3 show columns name
SQL
0 vote104 views1 answer
Gcloud check sql
SQL