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

3 votes393 views2 answers
Sqlite show table structure
SQL
0 vote334 views2 answers
Postgresql create role
SQL
2 votes401 views1 answer
Mysql select true or false
SQL
3 votes327 views1 answer
V$session not found in oracle
SQL
5 votes348 views2 answers
Mysql date greater than 30 days
SQL
0 vote357 views1 answer
Sql get number of days between two dates
SQL
8 votes340 views1 answer
Insert a select statement into a table
SQL
0 vote342 views1 answer
Sql server is not
SQL
-2 votes339 views2 answers
Sqlserver docker
SQL
0 vote329 views1 answer
Postgresql create table default value timestamp
SQL