Get last run query sql server

Sql server last executed query

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE dest.dbid = DB_ID('msdb')
ORDER BY deqs.last_execution_time DESC

SELECT dest.TEXT AS [Query],
deqs.execution_count [Count],
deqs.last_execution_time AS [Time]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC

Source: grepper.com

Similar codes

-1 vote274 views1 answer
Sql syntax create timestamp column
SQL
0 vote278 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote293 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote300 views1 answer
Alter column to not null with default value sql server
SQL
0 vote290 views2 answers
Mysql unique two columns
SQL
0 vote305 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
1 vote353 views1 answer
Mysql get max value and id
SQL
0 vote275 views1 answer
Sql inserted
SQL
0 vote279 views1 answer
Find most frequent value in SQL column
SQL
2 votes283 views1 answer
Oracle drop table free up space
SQL