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 vote233 views1 answer
Wordpress make wp user in db
SQL
1 vote199 views1 answer
Sql upsert
SQL
13 votes202 views2 answers
Sql online compiler
SQL
4 votes196 views1 answer
Data types in sql
SQL
14 votes189 views1 answer
Oracle new column
SQL
7 votes193 views4 answers
Database dump mysql command
SQL
1 vote193 views1 answer
Sql in array query
SQL
0 vote217 views2 answers
Amazon linux postgresql client
SQL
0 vote201 views1 answer
Insert array into mysql column
SQL
0 vote183 views1 answer
Mysql local password denied
SQL