Module assessment

1.

You're writing some error handling in a T-SQL script. If a problem arises, you want to raise an error with a severity of 20. Which command would you use to for this type of error handling?

THROW

RAISERROR

@@ERROR

2.

How can you THROW outside of a CATCH block?

With arguments that raise a user-defined error.

With a conditional EXCEPTION clause

With a RAISERROR argument.

3.

In what situation would you use @@ERROR?

To throw an error code.

To trigger an alert

To capture the last error code.

Feedback