how to get execution time of a sqlquery

Question

hi iam executing this query

select * from orders where Freight=71.97 and 250 > (select count(*) from orders where employeeid=Shipvia)

aginst northwind database of a sqlserver along with the result of this query i want time taken to execute this query in one column

please help me on this

Karan Patel · Answer

using System.Diagnostics; ================================== Stopwatch sw = new Stopwatch(); sw.Start(); // your sql query and your further task sw.Stop(); MessageBox.Show(sw.Elapsed.ToString());

Ashish Srivastava · Answer

Dear Pramod DECLARE @startTime datetime@endTime datetime SELECT @startTime=GETDATE() select * from orders where Freight=71.97 and 250 > (select count(*) from orders where employeeid=Shipvia) SELECT @endTime=GETDATE() SELECT DATEDIFF(ms@startDate@endDate) AS [Duration in millisecs] mark the answer if it helps you or Check this link http://www.c-sharpcorner.com/blogs/sql-query-time-execute-check1

kiran kumar · Answer

DECLARE @startTime datetime@endTime datetime SELECT @startTime=GETDATE() select * from orders where Freight=71.97 and 250 > (select count(*) from orders where employeeid=Shipvia) SELECT @endTime=GETDATE() SELECT DATEDIFF(ms@startDate@endDate) AS [Duration in millisecs] mark the answer if it helps you

Pramod Kumar Nandagiri · Answer

HI freind u have already given this i used it but for one query it is not giving same time at every execution  first time it gives some time and second time the execution time changes and third time it is diff thats why i want to get the time of execution of a query from the sql management studio it self plese tell me if any commands or function r there to get the executiontime from the sql mamnangement studio please tl\