/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 vote179 views1 answer
Mysql size int
SQL
1 vote154 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
11 votes203 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
17 votes200 views1 answer
Selecting name that contain certain word in sql
SQL
9 votes165 views3 answers
Mysql show table column full description
SQL
-1 vote167 views3 answers
Error mysql shutdown unexpectedly
SQL
3 votes178 views3 answers
Mysql order by list
SQL
0 vote202 views1 answer
Get create sql of hibernqte entity
SQL
1 vote154 views1 answer
Deleting database in sql
SQL
7 votes172 views1 answer
Mysql remote connection command line
SQL