Error Handling in SQL Server 2005 : Try catch « Transact SQL « SQL Server / T-SQL Tutorial

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

4>
5> CREATE PROCEDURE spDeleteProduct @Productid int
6> AS
7> BEGIN TRY
8>  BEGIN TRANSACTION
9>  DELETE Product WHERE ProductID = @ID
10>  COMMIT TRANSACTION
11> END TRY
12> BEGIN CATCH
13>  DECLARE @Err AS int
14>  DECLARE @Msg AS varchar(max)
15>  SET @Err = @@Error
16>  SET @Msg = Error_Message()
17>  ROLLBACK TRANSACTION
18>  INSERT ErrorTable
19>  VALUES (@err, @msg)
20> END CATCH
21> GO

1>
2>
3> drop PROCEDURE spProduct_Delete;
4> GO


1>
2>
3> drop table Product;
4> GO