SQL Query Execution time of you in SQL Management Studio

You can check the Execution time of you SQL Query in SQL Management Studio. like this

It is very simple that you just put your SQL Query in to the Estimated time execution query

 DECLARE @StartTime datetime  
 DECLARE @EndTime datetime  
 SELECT @StartTime=GETDATE()   
  -- Write Your Query  
 --This will return execution time of your query  
 SELECT DATEDIFF(NS,@StartTime,@EndTime) AS [Duration in millisecs]   

Popular posts from this blog

mvc razor textboxfor change event change another textboxfor value

WPF Crystal Report Viewer Using SAP

ASP.NET MVC razor SAP Crystal report