/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

10 votes192 views2 answers
Mysql drop database if exists
SQL
0 vote239 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote213 views1 answer
How to change the field size of an existing column
SQL
5 votes185 views2 answers
Update all rows mysql
SQL
1 vote173 views1 answer
Mysql datetime with timezone offset
SQL
0 vote187 views1 answer
Firebird where
SQL
0 vote175 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote202 views2 answers
How to check if sqlite table exists in nodejs
SQL
9 votes206 views6 answers
Oracle substring
SQL
1 vote168 views1 answer
Real world example of nosql
SQL