/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 vote332 views1 answer
Mysql root localhost run
SQL
10 votes350 views4 answers
Primary key in sql
SQL
0 vote329 views1 answer
EnvironmentError: mysql_config not found
SQL
2 votes347 views1 answer
Mariadb json select
SQL
2 votes323 views1 answer
Sql skip the first row
SQL
0 vote351 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
7 votes286 views1 answer
Alter table add key sql
SQL
3 votes323 views1 answer
Ssh check mysql version
SQL
4 votes327 views1 answer
Sql group by year
SQL
0 vote333 views1 answer
Drop constraint in ms sql
SQL