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 vote191 views2 answers
Mysql on update current_timestamp
SQL
0 vote211 views1 answer
Distance calculator from lat long sql query
SQL
0 vote201 views1 answer
Jdbc sql connection string
SQL
0 vote280 views1 answer
Sql select max value for each group
SQL
0 vote182 views1 answer
Get only first row mysql
SQL
0 vote195 views1 answer
Mysql docker image for macbook m1
SQL
2 votes192 views1 answer
While loop sql
SQL
0 vote232 views1 answer
Sql insert from excel
SQL
3 votes272 views3 answers
List columns in table postgres
SQL
0 vote207 views1 answer
Sql doesn't contain
SQL