These functions return data as UTC time (Coordinated Universal Time). In case of the GETUTCDATE(), the precision is in milliseconds. SYSUTCDATETIME() has a default precision of 7 digits after the seconds (aka nanoseconds). Continue reading What is the difference between the GETUTCDATE and SYSUTCDATETIME functions?
Tag Archives: function
#SqlServer interview question: What are ranking functions?
Ranking functions return a ranking value for each row in a partition. All the ranking functions are non-deterministic. Each of the ranking functions also needs the OVER( ) clause.
The different ranking functions are as follows: Continue reading #SqlServer interview question: What are ranking functions?