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

3 votes189 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote217 views1 answer
Create a plsql object
SQL
0 vote213 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote183 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
-1 vote180 views1 answer
Round up and down sql
SQL
0 vote217 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote221 views1 answer
Retornar apenas o ano mysql date
SQL
34 votes211 views6 answers
Sql change data type
SQL
1 vote171 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
3 votes181 views3 answers
Stop mysql ubuntu
SQL