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

7 votes209 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote270 views1 answer
Offset in postgresql example
SQL
15 votes178 views7 answers
MYSQL
SQL
0 vote184 views1 answer
Deleted table in sql trigger
SQL
0 vote192 views1 answer
Typeorm raw sql
SQL
0 vote201 views1 answer
Excel export from sql using python
SQL
0 vote189 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
7 votes178 views3 answers
Add primary key to database sql
SQL
1 vote182 views1 answer
Store select query result in variable sql server
SQL
2 votes191 views1 answer
Sql ignore accents
SQL