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