ALTER TABLE [TableName]
    ADD CONSTRAINT [CK_TableName_ABC] CHECK (
        (case when A is not NULL then 1 else 0 end +
        case when B is not NULL then 1 else 0 end +
        case when C is not NULL then 1 else 0 end)<=1
    )
GO