SQL @@TIMETICKS

SQL @@TIMETICKS is one of the System Statistical Function, which returns the number of microseconds per tick.

Syntax behind this is @@TIMETICKS is

@@TIMETICKS

SQL @@TIMETICKS Example

Below code snippet will show you the total number of microseconds per click for this SQL Server.

-- SQL Server @@TIMETICKS Example
SELECT @@TIMETICKS AS 'Time in No of MS'

OUTPUT

SQL @@TIMETICKS Example