Error Handling in SQL Server

In SQL Server 2005 and Above error handling can be done by using TRY CATCH Blocks. whereas for older versions like 2000 and below, we have depend on @@Error function.

Try - Catch

@@Error