Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
ALTER PROCEDURE [dbo].[pr_Expire] AS BEGIN SET NOCOUNT ON; --Calculate expiration date DECLARE @expire DATETIME SEt @expire = GETDATE() SET @expire = DATEADD(day,-60,@expire) --Expire all records older than @expire DELETE FROM dbo.CP_EquiP WHERE dtInsert < @expire END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.