You can handle errors in T-SQL almost the same way as in C# or Visual Basic. You can make use of a Try and catch block to trap errors and provide feedback on the error.
A small example follows:
BEGIN TRY SELECT * FROM TABLE WHERE Name LIKE '%Hannes%'END TRYBEGIN CATCHSELECT ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() as ErrorState, ERROR_PROCEDURE() as ErrorProcedure, ERROR_LINE() as ErrorLine, ERROR_MESSAGE() as ErrorMessage;END CATCH