Timing sql queries

DECLARE @t1 DATETIME;
DECLARE @t2 DATETIME;

SET @t1 = GETDATE();
SELECT /* query one */ 1 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

SET @t1 = GETDATE();
SELECT /* query two */ 2 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

Timing sql queries

SELECT GETDATE();
SELECT /* query one */ 1 ;
SELECT GETDATE();
SELECT /* query two */ 2 ; 
SELECT GETDATE();

-1

Source: stackoverflow.com

Similar codes

0 vote292 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote280 views1 answer
Table or view does not exist
SQL
0 vote322 views1 answer
Check constraint is violated
SQL
1 vote286 views1 answer
Flask sqlalchemy default value
SQL
0 vote280 views1 answer
SQL Server Enterprise
SQL
0 vote278 views1 answer
Call rest api from postgresql
SQL
18 votes282 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote271 views2 answers
Mysql type conversion
SQL
0 vote259 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote288 views1 answer
Oracle current timestamp insert statement
SQL