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 vote150 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote146 views1 answer
Apex ORA-20999
SQL
0 vote179 views1 answer
Which lock mode is not available in sql
SQL
3 votes142 views1 answer
Index using in query plsql
SQL
0 vote161 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote129 views1 answer
Sql server 2016 reseed identity
SQL
13 votes159 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote152 views1 answer
Pl sql join 3 tables
SQL
1 vote178 views1 answer
Default
SQL
5 votes139 views1 answer
Sql first day of current year
SQL