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 vote394 views1 answer
Gcloud sql list databases
SQL
0 vote398 views2 answers
Port 5432 is already in use mac
SQL
15 votes358 views2 answers
Select Options
SQL
1 vote342 views2 answers
Oracle replace
SQL
7 votes376 views5 answers
Sql remove spaces
SQL
3 votes402 views2 answers
Truncate table
SQL
3 votes396 views2 answers
How to force truncate a table in mysql
SQL
0 vote355 views2 answers
How to display enum value sql server
SQL
4 votes372 views1 answer
Alter session set nls_date_format
SQL
11 votes367 views2 answers
Insert date sql
SQL