/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

1 vote339 views1 answer
Expression number 1 of select list is not in group by clause
SQL
4 votes380 views1 answer
Mysql delete last row
SQL
2 votes340 views1 answer
Can you use a where clause for a child query
SQL
0 vote354 views1 answer
Sql date with year
SQL
6 votes326 views5 answers
Alter table oracle
SQL
0 vote312 views1 answer
Sql select all tables from database change url
SQL
2 votes325 views1 answer
How to check grants on a package in oracle
SQL
0 vote325 views1 answer
Create table Statement Syntax in SQL Server
SQL
4 votes350 views1 answer
Oracle nls_date_format
SQL
1 vote375 views1 answer
Delete dublicate rows sql
SQL