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

1 vote129 views1 answer
Add sequence postgres
SQL
0 vote137 views1 answer
Drop all data from tables
SQL
0 vote112 views1 answer
Oracle last user logon
SQL
0 vote147 views1 answer
Sql create and grant user access to database
SQL
0 vote186 views1 answer
Mysql update all record removing 2 hours from column
SQL
1 vote127 views1 answer
Sqlalchemy on delete set null
SQL
0 vote116 views1 answer
Create table sql generator
SQL
3 votes119 views1 answer
Locate sql server
SQL
0 vote110 views1 answer
List all permissions on a table in postgres
SQL
0 vote101 views1 answer
Sub blocks in sql
SQL