Using error functions

For every month, you want to know the total amount of money you earned in your bike store. Instead of reviewing every order line, you thought it would be better to prepare a script that computes it and displays the results.

While writing the script, you made a mistake. As you can see, the operation 'Total: ' + SUM(price * quantity) AS total is missing a cast conversion, causing an error.

How can we catch this error? Show the error number, severity, state, line, and message.

Bu egzersiz

Transactions and Error Handling in SQL Server

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

Surround the operation with a TRY block.
Surround the functions with a CATCH block.
Select the error information.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

-- Set up the TRY block
___ ___  	
	SELECT 'Total: ' + SUM(price * quantity) AS total
	FROM orders  
___ ___
-- Set up the CATCH block
___ ___  
	-- Show error information.
	SELECT  ___ AS number,  
        	___ AS severity_level,  
        	___ AS state,
        	___ AS line,  
        	___ AS message; 	
___ ___

Kodu Düzenle ve Çalıştır