如何在SQL server中检查存储过程或函数的最后更改日期

我需要查一下上次函数是什么时候改变的。我知道如何检查创建日期(它是在SQL Server Management Studio的函数属性窗口)。我发现在SQL Server 2000中不可能检查修改日期(看看这篇文章:是否有可能确定SQL Server 2000中存储过程最后一次修改的时间?)

在SQL Server 2008中可以检查吗?MS是否在系统表中添加了一些允许检查的新功能?

当前回答

对于SQL 2000，我将使用:

SELECT name, crdate, refdate 
FROM sysobjects
WHERE type = 'P' 
ORDER BY refdate desc

2013-08-19 09:20:56

其他回答

SELECT name, created_at, updated_at 
FROM table_name.column_name
WHERE type = 'soemthing'
ORDER BY updated_at DESC ;

我希望这将帮助你

2022-11-14 12:22:46

在存储过程中试试这个方法:

SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'myProc'

2011-04-07 10:01:07

对于SQL 2000，我将使用:

SELECT name, crdate, refdate 
FROM sysobjects
WHERE type = 'P' 
ORDER BY refdate desc

2013-08-19 09:20:56

我发现这是一项新技术

这是非常详细的

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo' 
order by  LAST_ALTERED desc

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'PROCEDURE' and ROUTINE_SCHEMA = N'dbo' 
order by  CREATED desc 


SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'FUNCTION' and ROUTINE_SCHEMA = N'dbo' 
order by  LAST_ALTERED desc

SELECT * FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = N'FUNCTION' and ROUTINE_SCHEMA = N'dbo' 
order by  CREATED desc

2016-10-20 06:25:42

SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF') 
AND name = 'dgdsgds'

2017-05-01 15:35:45

如何在SQL server中检查存储过程或函数的最后更改日期

推荐文章

最新文章

标签