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

4 votes128 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
4 votes122 views2 answers
Sql offset
SQL
2 votes110 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote127 views1 answer
Sql log file inof
SQL
2 votes115 views2 answers
Compare date mysql
SQL
11 votes137 views1 answer
Ddl view
SQL
3 votes121 views3 answers
Stop mysql ubuntu
SQL
1 vote124 views1 answer
Mysql month name extract
SQL
0 vote127 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote107 views1 answer
Find difference in dates sql
SQL