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 vote180 views1 answer
Postgresql concat string with separator
SQL
0 vote173 views1 answer
Check if mysql db is used
SQL
0 vote265 views1 answer
How to delete duplicate rows in oracle
SQL
4 votes146 views1 answer
Update table from another table oracle
SQL
9 votes147 views3 answers
Oracle undo usage by session
SQL
0 vote143 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote141 views3 answers
Postgres trim string
SQL
0 vote225 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote151 views1 answer
Test sql query
SQL
9 votes155 views4 answers
Postgresql export database
SQL