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 votes177 views1 answer
Dbms transaction (psql)
SQL
22 votes177 views1 answer
Mysql workbench
SQL
15 votes171 views4 answers
Sql update from select
SQL
0 vote149 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote96 views1 answer
How to get last client id sql
SQL
0 vote139 views1 answer
Show size of all tables postgres
SQL
0 vote138 views1 answer
C# datetime to sql server datetime
SQL
0 vote146 views1 answer
Mysql procedure between two tables
SQL
0 vote136 views1 answer
Mysql create table columns with spaces
SQL
1 vote161 views2 answers
Sql where is not number
SQL