USE [KO_DATABASE_SERVER_001]
GO
/****** Object: StoredProcedure [dbo].[UPDATE_TRASH_ITEMLIST] Script Date: 25.10.2023 15:26:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[UPDATE_TRASH_ITEMLIST]
AS
DECLARE @TICKCOUNT INT = DATEDIFF(s, '1970-01-01', GETUTCDATE())
IF (@TICKCOUNT > 0) DElETE FROM TRASH_ITEMLIST WHERE @TICKCOUNT > deletetime
USE [KO_DATABASE_SERVER_001]
GO
/****** Object: StoredProcedure [dbo].[UPDATE_TRASH_ITEMLIST] Script Date: 25.10.2023 15:26:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[UPDATE_TRASH_ITEMLIST]
AS
DECLARE @TICKCOUNT INT = DATEDIFF(s, '1970-01-01', GETUTCDATE())
IF (@TICKCOUNT > 0) DElETE FROM TRASH_ITEMLIST WHERE @TICKCOUNT > deletetime