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

0 vote148 views1 answer
Primary key multiple
SQL
0 vote149 views1 answer
Foreign key multiple columns
SQL
0 vote148 views1 answer
How to create a table based on another table in mysql
SQL
0 vote159 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote134 views1 answer
Oracle sql generate list of days
SQL
6 votes149 views4 answers
Mysql group by date
SQL
0 vote148 views1 answer
Sql query tags
SQL
3 votes141 views1 answer
Get all elements sql
SQL
1 vote159 views1 answer
Select inside insert query
SQL
0 vote131 views2 answers
Sql last updated
SQL