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 vote187 views1 answer
Mysql command prompt date insert format
SQL
24 votes186 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
2 votes194 views1 answer
Postgresql drop primary key constraint
SQL
1 vote171 views1 answer
Nested if in mysql
SQL
1 vote184 views2 answers
Mysql extract month
SQL
1 vote188 views1 answer
Mysql change root mysql_native_password
SQL
0 vote216 views1 answer
"Hello User Name"
SQL
1 vote188 views1 answer
Where database run
SQL
0 vote174 views1 answer
Mysql cdn link
SQL
1 vote196 views1 answer
How to copy data of a table from another database to table of anaother database
SQL