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

2 votes267 views2 answers
Checking data type in sql server
SQL
0 vote286 views1 answer
Shortcut run sql pgadmin
SQL
0 vote282 views1 answer
Helptext in sql
SQL
0 vote270 views1 answer
Sql delete dastabase
SQL
0 vote262 views1 answer
First mysql
SQL
-1 vote270 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote284 views1 answer
Group by join columns per table
SQL
2 votes281 views1 answer
Mysql trigger after update
SQL
0 vote277 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote263 views1 answer
Add constraint sql
SQL