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 vote259 views1 answer
Mysql month name extract
SQL
0 vote255 views1 answer
Mysql sql select one day before
SQL
0 vote250 views1 answer
RowDataPacket
SQL
2 votes264 views1 answer
Scaffold npgsql net core
SQL
2 votes277 views3 answers
Mysql kill
SQL
2 votes271 views2 answers
Postgres trigger insert into another table
SQL
51 votes430 views6 answers
Opera gx
SQL
0 vote257 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote248 views2 answers
How to type a blank discord messgae
SQL
1 vote201 views1 answer
Postgres reset auto increment
SQL