sql last last_execution_time

 SELECT execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery

CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql

ORDER BY execquery.last_execution_time DESC

Notepad++ cached files location

 https://stackoverflow.com/questions/29617349/notepad-cached-files-location

C:\Users\USER\AppData\Roaming\Notepad++\backup




semana del la semana sql server

    SELECT DATEPART(WEEK, @FechaInicio)  -

    DATEPART(WEEK, DATEADD(MM, DATEDIFF(MM,0,@FechaInicio ), 0))+ 1 AS SemanaMes

SELECT DATEPART(ISO_WEEK, @FechaInicio) as NumSemana