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

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

Sometimes we need to know how long a section of SQL statements takes to execute. Here is one of the options.

DECLARE @preDate Datetime
Select @preDate = getdate ()
print @preDate
Select datepart (MS, @preDate) as MS, DATEPART (SS, @preDate) as Second,datepart (MI, @preDate) as minute

go
--SQL statements that need to be tested go

declare @preDate Datetime
Select @preDate = getdate ()
Select DatePart (MS, @preDate) as MS, DATEPART (SS, @preDate) as second, DATEPART (MI, @preDate) as minute

This lets you know how many milliseconds your statement is running.