At least one of the resulting expressions in a CASE specification must be an expression other than the NULL constant

Asked

Viewed 10 times

0

INSERT INTO FILAS_CARTOES (COD_ASSOCIADO, SEQUENCIA_ADICIONAL, COD_USUARIO, DATA_REGISTRO, PROVISORIO, GERAR_SMS, STATUS, PRIORIDADE)
                VALUES (
                    @COD_ASSOCIADO
                    , CASE @SEQUENCIA_ADICIONAL WHEN 0 THEN NULL END
                    , @COD_USUARIO
                    , GETDATE()
                    , 'N'
                    , 'N'
                    , 'P'
                    , 1
                );

error: At least one of the resulting expressions in a CASE specification must be an expression other than the NULL constant.

That’s the mistake, what needs to be done, someone to help me?

sql sql-server

  • Please clarify your specific problem or provide Additional Details to Highlight Exactly what you need. As it’s Currently Written, it’s hard to Tell Exactly what you’re asking.

  • Alter your CASE for CASE @SEQUENCIA_ADICIONAL WHEN 0 THEN NULL ELSE @SEQUENCIA_ADICIONAL END

No answers

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.