This example is a simple stored procedure using a generic approach to error handling: : Error Handler « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Error Handler

5> CREATE PROCEDURE spRunSQL
6>  @Statement VarChar(2000)
7> AS
8> DECLARE @StartTime DateTime
9>    , @EndTime DateTime
10>    , @ExecutionTime Int
11>  SET @StartTime = GetDate()
12>  EXECUTE (@Statement)
13>  IF @@Error = 0
14>    BEGIN
15>    SET @EndTime = GetDate()
16>    SET @ExecutionTime = DateDiff(MilliSecond, @StartTime, @EndTime)
17>    RETURN @ExecutionTime
18>   END
19> GO
1>
2> drop proc spRunSQL;
3> GO