/SQL/Select true if exists on another table or false sqlserver

Select true if exists on another table or false sqlserver

  select A.name, 
       CASE WHEN B.name IS NOT NULL
       THEN 1
       ELSE 0
       END

    from table1 A
    left join table2 B
    on A.name = B.name

Source: stackoverflow.com

Similar codes

0 vote240 views1 answer
Get only first row mysql
SQL
15 votes284 views5 answers
If null mysql
SQL
0 vote280 views1 answer
Update having mysql
SQL
2 votes263 views2 answers
Mysql get time from datetime
SQL
0 vote281 views2 answers
Athena drop partition
SQL
0 vote221 views1 answer
Sqlalchemy filter relationship
SQL
3 votes288 views1 answer
DB: in eloquent using sql
SQL
8 votes269 views2 answers
Oracle auto increment primary key
SQL
0 vote259 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote297 views1 answer
Postgres dump sql insert
SQL