Gets the execution time of the SQL segment

Optimization of SQL often requires knowing the time of execution of this SQL statement, one of my common practices

DECLARE  @d DATETIMESET @d=GETDATE() --Do something--For ExampleSELECT *  fromTable1 with(NOLOCK)SELECT [statement execution takes time (milliseconds)]=DATEDIFF(MS,@d,getdate())

The DATEDIFF () function returns the number of days between two dates, usage DATEDIFF (datepart,startdate,enddate)

where StartDate and EndDate are to calculate the time difference between the start and end times datepart is the type of interval

　　

DatePart	Abbreviations
Years	YY, yyyy
Quarter	QQ, Q
Month	MM, M
The day of the year	Dy, y
Day	DD, D
Week	WK, WW
Week	DW, W
Hours	hh
Minutes	MI, n
Seconds	SS, S
Milliseconds	Ms
Subtle	MCs
Na-Sec	Ns

---restore content ends---

Gets the execution time of the SQL segment