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

6 votes212 views2 answers
Insert into select mysql
SQL
0 vote196 views1 answer
Python connect to mysql in settings.py
SQL
0 vote179 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote224 views1 answer
Pl sql round
SQL
1 vote253 views1 answer
Mysql connect command
SQL
-1 vote266 views1 answer
Minus vs except in sql
SQL
4 votes189 views3 answers
Is not null sql
SQL
2 votes172 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote184 views1 answer
Convert sql server guid to varbinary
SQL
0 vote206 views1 answer
Oracle step procedure
SQL