create procedure get_cost
@assetid as int
AS
BEGIN
DECLARE @msg varchar(200), @assetname as varchar(60) , @assetmain as float
Begin try
IF exists (Select @assetname = asset.name , @assetmain = asset_maintenance.cost
from asset
join asset_maintenance
on asset.id = asset_maintenance.asset_id
where asset_maintenance.id  = @assetid)
SET @msg = 'Maintenance cost of the asset ' + @assetname + 'is' + @assetmain
insert into success_log(success_msg) values(@msg)
end try
begin catch
SET @msg = 'No such asset'
insert into errors_log (error_msg) VALUES (@msg)
end catch
END