Tag: sql-server
Query to delete data before 90 days in 100-100 batches
DECLARE @DELETED_ROWS INT; SET @DELETED_ROWS = 100 WHILE (@DELETED_ROWS > 0) BEGIN WITH cte AS ( SELECT DATEADD(DAY, -90, UPDATEDDATE) AS date, audit_id FROM auditdata ) …
December 19, 2021
Written by: Maurice
DECLARE @DELETED_ROWS INT; SET @DELETED_ROWS = 100 WHILE (@DELETED_ROWS > 0) BEGIN WITH cte AS ( SELECT DATEADD(DAY, -90, UPDATEDDATE) AS date, audit_id FROM auditdata ) …
Hi, I am Maurice. I am From America, At the College of New Shelter,
When I took my first Experimental writing class. In any case, following a couple of short weeks. An auto repairman is a workman with an assortment of vehicle makes or either in a particular territory or in a particular make of car.
November 5, 2024
Electric vehicles (EVs) are well on their way to revolutionising the way we travel, offering an eco-friendly and efficient alternative to traditional fuel-driven cars. But with …
October 23, 2024
October 22, 2024
October 18, 2024