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.
Bu egzersiz
Transactions and Error Handling in SQL Server
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
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;