Hi,

The CATCH clause in SQL server does exactly what a catch(Exception ex) in C# does. Also the ROLLBACK is perfectly valid; imagine what would happen if there was no TRY.....

Nice QoTD :-).

An important point to remember is that a TRY..CATCH can be used to catch all database errors having the error number >10 that do not terminate a...