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 vote192 views1 answer
Show mysql account privilleges
SQL
0 vote129 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
1 vote146 views1 answer
Name of today sql
SQL
0 vote136 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
1 vote141 views1 answer
Table valued functions in sql
SQL
0 vote159 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
18 votes160 views3 answers
Mysql add column default value
SQL
0 vote132 views1 answer
Restore backupfile discourse
SQL
0 vote99 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
1 vote137 views1 answer
Mysql select update same table
SQL