DECLARE @x [int]
SET @x=30
SELECT [name] FROM [sys].[objects] WHERE [type]=’P’ AND DATEDIFF(d,[create_date], GETDATE()) < @x
SELECT [name] FROM [sys].[objects] WHERE [type]=’P’ AND DATEDIFF(d,[modify_date], GETDATE()) < @x
Otro sitio realizado con WordPress
DECLARE @x [int]
SET @x=30
SELECT [name] FROM [sys].[objects] WHERE [type]=’P’ AND DATEDIFF(d,[create_date], GETDATE()) < @x
SELECT [name] FROM [sys].[objects] WHERE [type]=’P’ AND DATEDIFF(d,[modify_date], GETDATE()) < @x