How to select a result of comparison operator as a field with type BIT?
How it does work in C#
:
bool isGreater = FieldA > FieldB;
How it doesn't work in T-SQL
:
SELECT (FieldA > FieldB) AS BIT FROM t
How to write such task properly?
You should use CASE clause:
CASE
WHEN FieldA > FieldB THEN 1
ELSE 0
END AS [BIT]