Get SSMS to show the time a query completed at?

Question

I'm using Sql Server Management Studio 2012, and I'm wondering if there is a way to have a query show me at what time it was run and/or completed at. Basically just some kind of timestamp so that I know if I actually ran the query recently or not.

Thanks

Answer 1

Hitting F4 also enables properties view, which shows the start time, finish time, and run time.

Also, if you Include Client Statistics (under Query menu), you can get a history of when you ran the query, along with various statistics such as run time and number of rows.

Update, 2019-10-14: SSMS 18 now includes the completion time in the Messages pane of the results tab.

Answer 2

You can do something like below :

declare @timer datetime
select @timer = getdate()

select @timer as QueryStartTime

--- here goes actual query
select * from sysdatabases
--- end of query

select getdate() as QueryEndTime
select datediff(ms, @timer, getdate()) as TimeInMS

Even though SSMS will show you how much time it took to execute the query, I have included the datediff.

Answer 3

A possible solution could be to run your query in a stored procedure (which usually has the added benefit of speeding up subsequent runs of your query, since the execution plan will be stored) and at the end of your SP, write something into a log table you created for that purpose. (Classic candidates could be name of the SP and getdate(), or even a result summary, if applicable)