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 vote340 views1 answer
Get schema of table sql
SQL
2 votes332 views2 answers
Mysql user access to database
SQL
0 vote338 views1 answer
Mysql select smaller of two values
SQL
0 vote326 views1 answer
Mariadb number format
SQL
0 vote325 views1 answer
Mysql count by month
SQL
0 vote313 views1 answer
Sql select non unique
SQL
7 votes349 views2 answers
Where keyword sql
SQL
0 vote332 views1 answer
SQL SELECT-Klausel
SQL
0 vote326 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
3 votes345 views2 answers
Postgres inner join vs join
SQL