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

0 vote232 views1 answer
Select last 2 characters sql
SQL
9 votes224 views3 answers
Mysql get last id
SQL
0 vote241 views2 answers
Sql query for getting details by id
SQL
0 vote230 views1 answer
Json not contains mysql
SQL
2 votes414 views1 answer
Oracle virtual column
SQL
-1 vote219 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote244 views1 answer
Sql common columns
SQL
0 vote248 views1 answer
Codeigniter 3 get best-selling products
SQL
-1 vote239 views2 answers
Postgresql user permissions to database
SQL
10 votes254 views2 answers
Select nextval from sequence oracle
SQL