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 vote203 views2 answers
Sql insert timestamp
SQL
0 vote250 views1 answer
Alternative for LIMIT sql
SQL
0 vote192 views1 answer
T-sql update table variale
SQL
4 votes187 views4 answers
What is primary key
SQL
7 votes231 views1 answer
Show line number in sql server
SQL
1 vote204 views1 answer
Quit mysql
SQL
0 vote246 views2 answers
Insert data into multiple tables mysql
SQL
0 vote222 views1 answer
Sqlcmd no headers
SQL
1 vote199 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote179 views1 answer
Count the table indatabase
SQL