Custom Error in MS-SQL server by RAISERROR (TSQL)

--Add message 
exec sp_addmessage @msgnum = 60000, @severity = 16,
@msgtext = 'The record has been modified already by other process',
@lang = 'us_english';
go
-- sample of usafe
if  @CurrCheckSum <> @xmlCheckSum
                RAISERROR (60000, 16, 1)
        ELSE

more...