This article Exception handing in SQL Server expains how we can handle the exception in our database programming and conditions which can't be handle by it.