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 vote331 views1 answer
Create view in mysql workbench
SQL
0 vote314 views1 answer
Group by two columns postgres
SQL
0 vote295 views1 answer
Test connection to sql server
SQL
0 vote295 views1 answer
Using GROUP BY in MySQL Join Table
SQL
15 votes312 views4 answers
Export mysql db using command line
SQL
21 votes305 views4 answers
Add column mssql
SQL
2 votes291 views1 answer
Oracle create directory
SQL
-1 vote339 views1 answer
Ms sql select datetime as date
SQL
0 vote290 views1 answer
Sql if else in select
SQL
0 vote292 views1 answer
TSQL function split string
SQL