Compare field sql server

SELECT 
  CASE WHEN COLUMN1 = COLUMN2 
    THEN '1' 
    ELSE '0' 
  END 
  AS MyDesiredResult
FROM Table1
INNER JOIN Table2 ON Table1.PrimaryKey = Table2.ForeignKey

Similar codes

2 votes232 views1 answer
How to insert string variable into sqlite database
SQL
0 vote213 views1 answer
Python mysql query where
SQL
0 vote269 views1 answer
Find and replace query in wordpress\
SQL
0 vote235 views1 answer
Get a list of tables and the primary key
SQL
0 vote248 views1 answer
Show tables in cassandra cql
SQL
0 vote258 views1 answer
Sql constarint
SQL
4 votes207 views1 answer
Postgresql show current database
SQL
0 vote269 views1 answer
FIND most frequent word in sql server
SQL
0 vote233 views1 answer
Sql query tags
SQL
1 vote253 views1 answer
Show databases mysql docker
SQL