SQLConfiguration SQLConfiguration


Server Interaction  «Prev 

SQL Raising Errors - Exercise

Exercise scoring

The objective of this exercise is to accurately create the Transact-SQL statement that raises the errors described in the instructions.

Exercise - Instructions

Construct two Transact-SQL statements, as follows:
  1. Raise an error with a severity of 25 and a state of 1 that uses the user-defined error message number 50210.
  2. Raise an error that does not exist in the sysmessages system catalog, but uses the text Object does not exist, with a severity level of 16 and a state of 1.

Submitting the exercise

Type or paste your Transact-SQL statements into the text box below, then click
Submit to submit them to the course tutor and view a Results page.