Consider the following code that calls SYSDATETIME() 10 million times in a loop:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
GO CREATE OR ALTER PROCEDURE #p_local AS BEGIN SET NOCOUNT ON; DECLARE @dummy DATETIME2(7), @loops INT = 0; WHILE @loops <= 10000000 BEGIN SET @dummy = SYSDATETIME(); SET @loops = @loops + 1; END; END; GO EXEC #p_local; |
On my machine the code takes…