TEST query execution time

by Ivan Gerasimenko

JavaScript

DECLARE @TextMessage NVARCHAR(255);
DECLARE @tb AS TABLE ( RandomInteger INT );
DECLARE @i INT;


DECLARE @StartTime DATETIME;
SET @StartTime = GETDATE();


-- TIME CONSUMING TASK
SET NOCOUNT ON;
SET @i = 0;
WHILE @i < 100000
BEGIN
	INSERT INTO @tb VALUES (RAND() * 10000);
	SET @i = @i + 1;
END
-- END TIME CONSUMING TASK


SET @TextMessage = 'Execution took ' + CONVERT(NVARCHAR(255), DATEDIFF(MS, @StartTime, GETDATE())) + ' ms.';
RAISERROR(@TextMessage, 0, 1) WITH NOWAIT;

SET NOCOUNT OFF;