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 vote105 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote96 views1 answer
Ms sql database data size
SQL
1 vote96 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote131 views1 answer
Day of the week sqlite
SQL
0 vote106 views2 answers
Get item by composite primary key mysql
SQL
1 vote102 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote102 views1 answer
Oracle sql date winter time
SQL
0 vote108 views1 answer
Postgresql auto increment not working
SQL
-1 vote103 views1 answer
Mysql select count if contains
SQL
0 vote103 views1 answer
How to set all the min and sec data to zero in sql server
SQL