Method for obtaining the execution time of SQL statements

Found online:

-- Before an SQL statement, add:
Declare   @ D   Datetime
Set   @ D = Getdate ()
-- SQL statement
-- Add the following after the SQL statement:
Select   [ Statement execution time (MS) ] = Datediff (MS, @ D , Getdate ())

The query results cannot be intuitively displayed in the query analyzer. You have improved the query results by yourself: -- Before an SQL statement, add:
Declare   @ D   Datetime
Set   @ D = Getdate ()
-- SQL statement
-- Add the following after the SQL statement:
Select   @ D   As   ' Start Time ' ,Getdate()  As   ' End Time ' , Datediff (MS, @ D ,Getdate()) As   ' Execution time '

However, this method cannot produce results for queries that consume a small amount of time. I don't know what other software and methods can be used to obtain the exact execution time of SQL statements.