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

16 votes310 views2 answers
Mysql date between two dates
SQL
0 vote285 views2 answers
Transaction php
SQL
9 votes277 views4 answers
How to remove duplicate in sql
SQL
58 votes497 views4 answers
Mysql drop column
SQL
0 vote307 views1 answer
Oracle 11g forget password
SQL
0 vote316 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote287 views1 answer
How to use group_concat in sql server
SQL
31 votes279 views1 answer
Postgresql add column with constraint
SQL
0 vote267 views1 answer
Myswql show full processlist
SQL
1 vote269 views2 answers
Difference between in and between in sql
SQL