junfkt2
12/6/2014 - 4:57 PM

查找存储过程的最后修改时间

查找存储过程的最后修改时间

SELECT name,modify_date FROM sys.objects ORDER BY modify_date DESC


IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'rptGetForecastListOfElectric') AND type in (N'P', N'PC'))
DROP PROCEDURE rptGetForecastListOfElectric