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 vote402 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote345 views1 answer
Sql select table header
SQL
4 votes387 views4 answers
Date less than in sql
SQL
0 vote366 views2 answers
Advantages of stored procedures sql
SQL
-1 vote354 views1 answer
Su: Authentication failure mysql
SQL
103 votes589 views1 answer
Like sql
SQL
1 vote434 views1 answer
STOP message of how many rows affected sql
SQL
0 vote409 views1 answer
Create a plsql object
SQL
0 vote382 views1 answer
Store case result sql
SQL
0 vote362 views1 answer
Sql pad left 0
SQL