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 vote311 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote345 views1 answer
Transaction and commit trong sql server
SQL
0 vote289 views1 answer
How to export table data from mysql table in sql format
SQL
14 votes294 views2 answers
How to auto increment in sql
SQL
5 votes319 views1 answer
Mysql created at yesterdau
SQL
0 vote313 views1 answer
Mssql now diff 90 day
SQL
0 vote298 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote326 views1 answer
Basic structure of sql expression having clause
SQL
0 vote325 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
2 votes314 views1 answer
How to find constraints on a table in oracle
SQL