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 vote283 views1 answer
Declare date variable sql
SQL
0 vote282 views1 answer
Set mysql socket file docker windows
SQL
0 vote282 views1 answer
Drop all tables db2
SQL
16 votes329 views1 answer
Sqlserver add column to table
SQL
3 votes305 views1 answer
Sql case update
SQL
0 vote275 views1 answer
Flask sqlalchemy decimal
SQL
0 vote285 views1 answer
Trigger stock phpmyadmin output message
SQL
28 votes248 views6 answers
Distinct sql
SQL
22 votes281 views4 answers
Tsql rename table
SQL
3 votes299 views1 answer
Start mysql server by terminal in linux
SQL