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 vote125 views1 answer
Doesn't have default value mysql
SQL
0 vote131 views1 answer
Oracle right characters
SQL
5 votes123 views1 answer
Update sql user password
SQL
0 vote135 views1 answer
Trigger vérifier stock
SQL
0 vote134 views1 answer
Geopoint from json mysql function
SQL
2 votes120 views1 answer
Ssh mysql port forwarding
SQL
1 vote111 views1 answer
Tsql update datetime
SQL
2 votes131 views1 answer
Express api ith mysql data
SQL
1 vote113 views1 answer
Tsql random number
SQL
5 votes139 views1 answer
Oracle list days between two dates
SQL