SQL Server T-SQL: error handling

The throw statement

In a catch block, the severity level can be determined with error_severity().

raisError()

sys.sysmessages