sql - SQL SERVER 2005如果是

Question

我正在运行以下查询。

SELECT T1.C1, T2.C2..., 
IF( T1.C1<>T2.C1,"Changed","1") AS NewColumn
From T1 INNER JOIN T2
Where condition..

我收到IF语句的语法错误。

目的是比较两个不同表中的列，如果不相等，则另存为第三个表的NewColumn中的“Changed”。这是 Insert INTO query。

T-> Table
C->Column

Answer 1

SELECT T1.C1, T2.C2..., 
    CASE WHEN T1.C1<>T2.C1 THEN 'Changed' ELSE '1' END AS NewColumn 
From T1 INNER JOIN T2 ON ... 
Where ...