How to view the execution time of an SQL statement on SQL Server

1: The following is a relatively simple query method, through the query before the time and query after the difference between the calculation of
Copy Code code 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 ' spents/millisecond '


2: The following method is more comprehensive, the steps taken to execute each statement are returned as a rowset, presented in the form of a hierarchy tree
Copy Code code 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