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

1 vote210 views1 answer
Insert value to new table by joining 2 different tables
SQL
2 votes201 views1 answer
Oracle convert run_duration to number
SQL
-1 vote207 views1 answer
Add bool column in sql
SQL
7 votes194 views5 answers
Show details of table postgres
SQL
2 votes176 views1 answer
How to delete columns in sql
SQL
0 vote209 views1 answer
Postgres change the name of schema
SQL
0 vote196 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
22 votes241 views1 answer
Mysql workbench
SQL
1 vote269 views3 answers
Date_add mysql
SQL
1 vote212 views1 answer
Oracle activate job
SQL