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 vote147 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote136 views1 answer
How to delete data from sql database in android
SQL
0 vote146 views1 answer
How to select all fieldsin a soql query
SQL
0 vote133 views1 answer
Dasebase_url-postgres for windows
SQL
4 votes148 views4 answers
Oracle tablespace tables list
SQL
1 vote97 views1 answer
Full text index mysql
SQL
0 vote138 views1 answer
Mysql autoincrement valor inicial
SQL
18 votes146 views3 answers
Mysql number format
SQL
6 votes160 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
3 votes149 views1 answer
How to find names includes in sql
SQL