SQL Server/T-SQL Tutorial/Transact SQL/Error Handler

This example is a simple stored procedure using a generic approach to error handling:

   <source lang="sql">

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</source>