/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

5 votes233 views2 answers
Functions
SQL
0 vote222 views1 answer
Hashpass
SQL
0 vote148 views1 answer
Oracle list all stored procedures
SQL
4 votes226 views2 answers
Oracle unliock account
SQL
0 vote201 views3 answers
How to run sql query
SQL
15 votes180 views7 answers
MYSQL
SQL
0 vote209 views1 answer
Postgresql function ROUND
SQL
0 vote208 views1 answer
Sql server convert to guid
SQL
0 vote200 views1 answer
SQL Server modify_timestamp trigger
SQL
2 votes238 views1 answer
Show max_allowed_packet mysql
SQL