la gestion des erreurs en sql serverFermé

Question

Bonjour,
j'ai crée une procédure qui contient deux paramètres, et je veux afficher une erreur quand une de ces Deux paramètres n'est pas fourni 
je sais pas comment faire et ou je dois mettre l'instruction?????????

holow1 · Answer

bonjour,

voici un exemple d'un cour(.CMH) complet en anglais pour sql server 2005 

 USE AdventureWorks

    BEGIN TRY
      UPDATE HumanResources.Employee
      SET Gender = 'X'
      WHERE EmployeeID = 1;
    END TRY
    BEGIN CATCH
      SELECT ERROR_NUMBER(  ) ErrorNumber,
      ERROR_STATE(  ) ErrorState,
      ERROR_SEVERITY(  ) ErrorSeverity,
      ERROR_MESSAGE(  ) ErrorMessage;
    END CATCH



As shown in the example, you can use the following functions to return information about the error caught by a CATCH block:



ERROR_MESSAGE( )

Diagnostic information about the error. These messages often contain substitution variables that allow specific information, such as the database object that caused the error, to be included in the message.



ERROR_NUMBER( )

The unique error number of the error. The ERROR_NUMBER( ) function returns the last error number every time it is called. This is different from @@ERROR, which works only if it immediately follows the error or is the first statement in the CATCH block.



ERROR_SEVERITY( )

The severity level of the error. Error severities range from 0 to 24. Error levels 0 to 9 are warnings or informational.



ERROR_STATE( )

The state of the error. A state code uniquely identifies specific conditions that cause errors with the same error number.


c'est vous étiez intéresse passer ton Email ^_^

La gestion des erreurs en sql server

1 réponse

Discussions similaires

Newsletters