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 vote364 views1 answer
How to select all fieldsin a soql query
SQL
2 votes351 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote344 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote316 views1 answer
Hangfire clean script
SQL
0 vote317 views1 answer
What is the essence of SQL?
SQL
0 vote365 views1 answer
Postgresql check total storage
SQL
2 votes384 views2 answers
Create temporary table in mysql
SQL
16 votes345 views2 answers
Add column if not exists mysql
SQL
0 vote330 views1 answer
Import sql dump into postgresql database
SQL
5 votes352 views1 answer
Dbms_metadata.get_ddl table
SQL