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 vote127 views1 answer
Mariadb get column names from table
SQL
1 vote125 views1 answer
Check message id sql server
SQL
0 vote127 views1 answer
Amount of entries in a table psql
SQL
0 vote125 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote113 views1 answer
Kotlin sqlite delete row
SQL
0 vote125 views1 answer
Double in sql server example
SQL
7 votes130 views2 answers
Execute mysql file
SQL
0 vote169 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote190 views1 answer
Placements hackerrank solution
SQL
0 vote132 views1 answer
Add unique constraint sql server multiple columns
SQL