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 vote115 views1 answer
Ffeathers express mysql application users login
SQL
8 votes93 views3 answers
Duplicate entry
SQL
0 vote117 views2 answers
How to generate a unique random number in mysql
SQL
1 vote102 views1 answer
Sql upsert
SQL
0 vote132 views1 answer
How to check foreign key constraint in sql
SQL
0 vote108 views1 answer
Sqlite higher or equal
SQL
0 vote107 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote74 views1 answer
Mysql timeout 30 seconds
SQL
1 vote110 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote130 views1 answer
Sql server information_schema temp tables
SQL