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

5 votes219 views1 answer
Add column table sql default value
SQL
0 vote196 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
4 votes169 views2 answers
Mysql how to change default charset
SQL
-1 vote198 views1 answer
Pl sql drop trigger
SQL
0 vote217 views1 answer
Sql query wordpress export post
SQL
0 vote195 views1 answer
PostgreSQL types and C# types
SQL
0 vote179 views1 answer
Get cpu details sql
SQL
4 votes176 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote183 views1 answer
Import sql dump into postgresql database
SQL
0 vote177 views1 answer
Mysql add to value
SQL