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 votes178 views3 answers
Sql drop primary key
SQL
0 vote172 views2 answers
Starting mysql service from mac
SQL
3 votes161 views3 answers
Update join
SQL
0 vote222 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote179 views2 answers
Oracle select
SQL
0 vote205 views1 answer
Sql quary stuf
SQL
0 vote257 views1 answer
Delet all record statment sql
SQL
0 vote175 views1 answer
Mysql changer nom table
SQL
0 vote177 views1 answer
Postgres data location
SQL
1 vote168 views2 answers
Mysql order by date asc null last
SQL