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

3 votes331 views2 answers
Mysql import gz
SQL
13 votes338 views2 answers
Sql join 3 tables
SQL
0 vote336 views1 answer
Materialized view redshift
SQL
0 vote327 views1 answer
Oracle DROP PROGRAM
SQL
0 vote348 views2 answers
Replace null with 0 in sql
SQL
0 vote314 views1 answer
Mysql procedure between two tables
SQL
2 votes347 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote348 views1 answer
Nvl2 syntax
SQL
16 votes344 views3 answers
Update table from another table
SQL
0 vote408 views1 answer
Trigger
SQL