try...catch Demo : Try catch « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Try catch

7> CREATE TABLE SomeData
8> (
9>     SomeColumn INT
10> )
11> GO
1>
2> BEGIN TRANSACTION
3>
4> BEGIN TRY
5>     --Throw an exception on insert
6>     INSERT SomeData VALUES (CONVERT(INT, 'abc'))
7> END TRY
8> BEGIN CATCH
9>     --Try to commit...
10>     COMMIT TRANSACTION
11> END CATCH
12> GO
Msg 3930, Level 16, State 1, Server J\SQLEXPRESS, Line 10
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
1>
2>
3> drop table SomeData;
4> GO