How to view the execution time of SQL statements on SQLServer

1: The following is a simple query method. It is calculated based on the time difference between the query time and the query time.
Copy codeThe Code is as follows:
Declare @ begin_date datetime
Declare @ end_date datetime
Select @ begin_date = getdate ()
<Write your statement here...>
Select @ end_date = getdate ()
Select datediff (MS, @ begin_date, @ end_date) as 'time/millisecond'


2: The following method is comprehensive. The steps taken when each statement is executed are returned as a row set and are displayed in the form of a hierarchy tree.
Copy codeThe Code is as follows:
Set statistics profile on
Set statistics io on
Set statistics time on
Go
<Write your statement here...>
Go
Set statistics profile off
Set statistics io off
Set statistics time off