Get startedGet started for free

CATCHING the RAISERROR

You need to select a product from the products table using a given product_id.

If the select statement doesn't find any product, you want to raise an error using the RAISERROR statement. You also need to catch possible errors in the execution.

This exercise is part of the course

Transactions and Error Handling in SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

DECLARE @product_id INT = 5;

IF NOT EXISTS (SELECT * FROM products WHERE product_id = @product_id)
	-- Invoke RAISERROR with parameters
	___('No product with id %d.', ___, ___, ___);
ELSE 
	SELECT * FROM products WHERE product_id = @product_id;
Edit and Run Code