How are exceptions handled in the procedure?

857    Asked by JasonSharp in SQL Server , Asked on Jan 9, 2020
Answered by Jason Sharp

Error occurred during the execution of procedure is known as exception, this can occur at server level, database level or can be raised by user on the base of some data.

This can be handled and specific tasks can be performed on getting an exception.

To handle such cases the code is written between try block and we have a catch block which will help in to manage the error, some steps can be taken if the error occurs.

image


Your Answer

Interviews

Parent Categories