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 vote157 views2 answers
Drop table if exists test
SQL
0 vote134 views1 answer
Sql server manager close connection
SQL
11 votes141 views6 answers
Distinct sql
SQL
4 votes142 views1 answer
Mac install mysql
SQL
0 vote154 views1 answer
Count in sql and diff
SQL
0 vote141 views1 answer
Postgres 11 add primary key
SQL
6 votes134 views1 answer
Oracle trigger after logon on database
SQL
0 vote140 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote90 views1 answer
Oracle list all stored procedures
SQL
0 vote160 views1 answer
Connecting mySQL to STS
SQL