top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the various types of Exceptions?

+2 votes
253 views
What are the various types of Exceptions?
posted Nov 26, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
 
Best answer

Types of Exceptions

1.Statement-Level Exception
This type of exception aborts only the current running statement within a batch of T-SQL statements. The rest of the T-SQL statements will execute successfully if they have no exceptions.
2.Batch-Level Exception
This type of exception aborts only the batch in which exception occurs. The rest of the batches will execute successfully if they have no exceptions. The statement in which exception occurs will be aborted and the remaining T-SQL statements within the batch will also stopped.
3.Parsing and Scope-Resolution Exception
This types of exception occurs during the parsing and during the scope-resolution phase of compilation. This exception appears to behave just like batch-level exceptions. However, this has a little different behavior.
If the exception occurs in the same scope of the batch, it behaves just like a batch-level exception.If the exception occurs in a lower level of scope of the batch, it behaves just like statement-level exception.

answer Nov 28, 2014 by Manikandan J
...