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 vote157 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote155 views1 answer
Inserted row count tsql
SQL
0 vote163 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
1 vote142 views1 answer
Use of now() in mysql
SQL
0 vote147 views1 answer
Oracle query archive mode
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL
0 vote188 views1 answer
Postgresql concat string with separator
SQL
1 vote170 views1 answer
PL SQL MODIFY COLUMN NME
SQL
5 votes191 views1 answer
How to get all table names in sql query
SQL
0 vote188 views1 answer
Download mysql database to excel in android studio
SQL