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

23 votes174 views6 answers
Delete all rows from table sql
SQL
0 vote179 views1 answer
Set default value now() date
SQL
104 votes289 views2 answers
Like in mysql
SQL
1 vote147 views2 answers
Procedure pl/sql
SQL
0 vote172 views3 answers
Insert or ignore postgres
SQL
-1 vote183 views1 answer
Round up and down sql
SQL
0 vote175 views1 answer
Safe mysql
SQL
0 vote201 views1 answer
Selecting Multiple Columns in SQL
SQL
8 votes183 views1 answer
Oracle search code in packages
SQL
0 vote189 views1 answer
Custom row number
SQL